Overview

Brought to you by YData

Dataset statistics

	Raw Dataset Profile	Preprocessed Dataset Profile
Number of variables	53	16
Number of observations	70423	19359
Missing cells	842045	13470
Missing cells (%)	22.6%	4.3%
Duplicate rows	0	0
Duplicate rows (%)	0.0%	0.0%
Total size in memory	147.8 MiB	26.7 MiB
Average record size in memory	2.1 KiB	1.4 KiB

Variable types

	Raw Dataset Profile	Preprocessed Dataset Profile
Numeric	15	2
Text	30	14
DateTime	4	0
Unsupported	4	0

Alerts

Raw Dataset Profile	Preprocessed Dataset Profile
`ref` has constant value "GARANTIA-ES"	Alert not present in this dataset	Constant
`company_id` is highly overall correlated with `dire_recogida_id` and 3 other fields	Alert not present in this dataset	High correlation
`dire_envio_id` is highly overall correlated with `dire_recogida_id`	Alert not present in this dataset	High correlation
`dire_recogida_id` is highly overall correlated with `company_id` and 3 other fields	Alert not present in this dataset	High correlation
`estado` is highly overall correlated with `id_estado`	Alert not present in this dataset	High correlation
`estadofr` is highly overall correlated with `id_tipo` and 1 other fields	Alert not present in this dataset	High correlation
`id` is highly overall correlated with `id_pieza`	Alert not present in this dataset	High correlation
`id_estado` is highly overall correlated with `estado`	Alert not present in this dataset	High correlation
`id_pieza` is highly overall correlated with `id`	Alert not present in this dataset	High correlation
`id_tipo` is highly overall correlated with `estadofr` and 1 other fields	Alert not present in this dataset	High correlation
`tipo` is highly overall correlated with `estadofr` and 1 other fields	Alert not present in this dataset	High correlation
`user_id` is highly overall correlated with `company_id` and 2 other fields	Alert not present in this dataset	High correlation
`user_id_pieza` is highly overall correlated with `company_id` and 2 other fields	Alert not present in this dataset	High correlation
`volumen3` is highly overall correlated with `company_id`	Alert not present in this dataset	High correlation
`modification_date` has 8751 (12.4%) missing values	Alert not present in this dataset	Missing
`pedido_sage` has 70423 (100.0%) missing values	Alert not present in this dataset	Missing
`abono_sage` has 70423 (100.0%) missing values	Alert not present in this dataset	Missing
`pedido_a3` has 9730 (13.8%) missing values	Alert not present in this dataset	Missing
`abono_a3` has 23679 (33.6%) missing values	Alert not present in this dataset	Missing
`personaaz` has 32790 (46.6%) missing values	Alert not present in this dataset	Missing
`dire_envio_id` has 27434 (39.0%) missing values	Alert not present in this dataset	Missing
`dire_recogida_id` has 26779 (38.0%) missing values	Alert not present in this dataset	Missing
`peso3` has 28236 (40.1%) missing values	Alert not present in this dataset	Missing
`volumen3` has 70418 (> 99.9%) missing values	Alert not present in this dataset	Missing
`c_mail` has 67591 (96.0%) missing values	Alert not present in this dataset	Missing
`c_tel` has 67202 (95.4%) missing values	Alert not present in this dataset	Missing
`c_obs` has 68233 (96.9%) missing values	Alert not present in this dataset	Missing
`accepted_client` has 62173 (88.3%) missing values	Alert not present in this dataset	Missing
`desc_problema` has 4741 (6.7%) missing values	Alert not present in this dataset	Missing
`codigo_incidencia` has 1426 (2.0%) missing values	Alert not present in this dataset	Missing
`id_pieza` has 1426 (2.0%) missing values	Alert not present in this dataset	Missing
`user_id_pieza` has 1426 (2.0%) missing values	Alert not present in this dataset	Missing
`cod_articulo` has 1435 (2.0%) missing values	Alert not present in this dataset	Missing
`descripcion` has 19536 (27.7%) missing values	Alert not present in this dataset	Missing
`num_serie` has 1508 (2.1%) missing values	Alert not present in this dataset	Missing
`factura_albaran` has 30101 (42.7%) missing values	Alert not present in this dataset	Missing
`problema` has 1427 (2.0%) missing values	Alert not present in this dataset	Missing
`is_replacement` has 1426 (2.0%) missing values	Alert not present in this dataset	Missing
`creation_date_pieza` has 1426 (2.0%) missing values	Alert not present in this dataset	Missing
`modification_date_pieza` has 1426 (2.0%) missing values	Alert not present in this dataset	Missing
`titulo_pt` has 70423 (100.0%) missing values	Alert not present in this dataset	Missing
`titulo_pt_tipo` has 70423 (100.0%) missing values	Alert not present in this dataset	Missing
`peso3` is highly skewed (γ1 = 205.1225851)	Alert not present in this dataset	Skewed
`id_pieza` is uniformly distributed	Alert not present in this dataset	Uniform
`pedido_sage` is an unsupported type, check if it needs cleaning or further analysis	Alert not present in this dataset	Unsupported
`abono_sage` is an unsupported type, check if it needs cleaning or further analysis	Alert not present in this dataset	Unsupported
`titulo_pt` is an unsupported type, check if it needs cleaning or further analysis	Alert not present in this dataset	Unsupported
`titulo_pt_tipo` is an unsupported type, check if it needs cleaning or further analysis	Alert not present in this dataset	Unsupported
`estadofr` has 8624 (12.2%) zeros	Alert not present in this dataset	Zeros
Alert not present in this dataset	`desc_problema_translated` has 543 (2.8%) missing values	Missing
Alert not present in this dataset	`descripcion_translated` has 3752 (19.4%) missing values	Missing
Alert not present in this dataset	`CAR4` has 9174 (47.4%) missing values	Missing
Alert not present in this dataset	`id_pieza` has unique values	Unique

Reproduction

	Raw Dataset Profile	Preprocessed Dataset Profile
Analysis started	2024-12-29 10:08:27.202705	2024-12-29 10:09:49.965068
Analysis finished	2024-12-29 10:09:16.938652	2024-12-29 10:09:53.562379
Duration	49.74 seconds	3.6 seconds
Software version	ydata-profiling vv4.12.1	ydata-profiling vv4.12.1
Download configuration	config.json	config.json

id
Real number (ℝ)

Distinct	45183
Distinct (%)	64.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	42013.347

Minimum	19552
Maximum	64750
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	619.1 KiB

Quantile statistics

Minimum	19552
5-th percentile	21855.1
Q1	30759.5
median	42030
Q3	53026
95-th percentile	62304.9
Maximum	64750
Range	45198
Interquartile range (IQR)	22266.5

Descriptive statistics

Standard deviation	12919.063
Coefficient of variation (CV)	0.30749901
Kurtosis	-1.1881978
Mean	42013.347
Median Absolute Deviation (MAD)	11130
Skewness	0.0016870059
Sum	2.9587059 × 10⁹
Variance	1.6690218 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
40833	146	0.2%
42953	95	0.1%
58596	64	0.1%
25643	60	0.1%
54003	59	0.1%
27115	57	0.1%
47498	57	0.1%
42244	56	0.1%
21319	56	0.1%
46170	50	0.1%
Other values (45173)	69723	99.0%

Value	Count	Frequency (%)
19552	2	< 0.1%
19553	1	< 0.1%
19554	10	< 0.1%
19555	1	< 0.1%
19556	1	< 0.1%
19557	3	< 0.1%
19558	1	< 0.1%
19559	1	< 0.1%
19560	1	< 0.1%
19561	1	< 0.1%

Value	Count	Frequency (%)
64750	1	< 0.1%
64749	6	< 0.1%
64748	1	< 0.1%
64747	1	< 0.1%
64746	1	< 0.1%
64745	1	< 0.1%
64744	1	< 0.1%
64743	1	< 0.1%
64742	1	< 0.1%
64741	1	< 0.1%

web_id
Real number (ℝ)

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.637803

Minimum	1
Maximum	5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	619.1 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	2
95-th percentile	3
Maximum	5
Range	4
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.70092909
Coefficient of variation (CV)	0.42796911
Kurtosis	0.31401878
Mean	1.637803
Median Absolute Deviation (MAD)	1
Skewness	0.8086284
Sum	115339
Variance	0.49130159
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=4)

Value	Count	Frequency (%)
1	34150	48.5%
2	27978	39.7%
3	8121	11.5%
5	174	0.2%

Value	Count	Frequency (%)
1	34150	48.5%
2	27978	39.7%
3	8121	11.5%
5	174	0.2%

Value	Count	Frequency (%)
5	174	0.2%
3	8121	11.5%
2	27978	39.7%
1	34150	48.5%

codigo
['Text', 'Text']

	Raw Dataset Profile	Preprocessed Dataset Profile
Distinct	45183	15226
Distinct (%)	64.2%	78.7%
Missing	0	0
Missing (%)	0.0%	0.0%
Memory size	4.5 MiB	1.2 MiB

Length

	Raw Dataset Profile	Preprocessed Dataset Profile
Max length	10	10
Median length	10	10
Mean length	10	10
Min length	10	10

Characters and Unicode

	Raw Dataset Profile	Preprocessed Dataset Profile
Total characters	704230	193590
Distinct characters	36	36
Distinct categories	2	2 ?
Distinct scripts	2	2 ?
Distinct blocks	1	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

	Raw Dataset Profile	Preprocessed Dataset Profile
Unique	36725	13191 ?
Unique (%)	52.1%	68.1%

Sample

	Raw Dataset Profile	Preprocessed Dataset Profile
1st row	MGHQM2LT55	MMZPL2LO50
2nd row	MGHQM2LT55	MMZPL2LO50
3rd row	LMPOM2TR8B	MMZPL2LO50
4th row	LMNWLG1U1A	L2VQL2LVF3
5th row	LMNWLG1U1A	LGRPLMLUAE

Value	Count	Frequency (%)
bgvjymat77	146	0.2%
m5iwmzznd9	95	0.1%
m2dqbgdm0b	64	0.1%
am9pa21s32	60	0.1%
ljqcmz1m00	59	0.1%
b29ozmzv3e	57	0.1%
m5ebm5dj2f	57	0.1%
y2plz2ky3a	56	0.1%
k2lrmg5r5b	56	0.1%
njgel5plb9	50	0.1%
Other values (45173)	69723	99.0%

Value	Count	Frequency (%)
ljgbmptkdd	30	0.2%
ljgwljdh31	27	0.1%
agxlzwoxb3	25	0.1%
bgtta2lw64	24	0.1%
zmtlz2sy49	24	0.1%
ag1jyggzba	23	0.1%
zmdpzwmcb8	22	0.1%
zwliymcc1b	22	0.1%
awdpywcv33	21	0.1%
zmpoa2zvdc	20	0.1%
Other values (15216)	19121	98.8%

Most occurring characters

Value	Count	Frequency (%)
M	62637	8.9%
Z	47777	6.8%
A	41249	5.9%
L	40895	5.8%
2	35577	5.1%
W	35262	5.0%
G	32352	4.6%
P	29018	4.1%
N	27928	4.0%
B	26003	3.7%
Other values (26)	325532	46.2%

Value	Count	Frequency (%)
M	16536	8.5%
Z	13193	6.8%
A	11705	6.0%
L	11297	5.8%
W	9959	5.1%
2	9278	4.8%
G	9016	4.7%
B	8130	4.2%
P	7863	4.1%
5	6315	3.3%
Other values (26)	90298	46.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	567916	80.6%
Decimal Number	136314	19.4%

Value	Count	Frequency (%)
Uppercase Letter	155220	80.2%
Decimal Number	38370	19.8%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
M	62637	11.0%
Z	47777	8.4%
A	41249	7.3%
L	40895	7.2%
W	35262	6.2%
G	32352	5.7%
P	29018	5.1%
N	27928	4.9%
B	26003	4.6%
D	21524	3.8%
Other values (16)	203271	35.8%

Value	Count	Frequency (%)
M	16536	10.7%
Z	13193	8.5%
A	11705	7.5%
L	11297	7.3%
W	9959	6.4%
G	9016	5.8%
B	8130	5.2%
P	7863	5.1%
N	6016	3.9%
D	5933	3.8%
Other values (16)	55572	35.8%

Decimal Number

Value	Count	Frequency (%)
2	35577	26.1%
5	21034	15.4%
1	15557	11.4%
9	10751	7.9%
3	9209	6.8%
0	9038	6.6%
4	8937	6.6%
7	8795	6.5%
8	8772	6.4%
6	8644	6.3%

Value	Count	Frequency (%)
2	9278	24.2%
5	6315	16.5%
1	4776	12.4%
9	3162	8.2%
3	2640	6.9%
4	2507	6.5%
7	2475	6.5%
8	2439	6.4%
0	2398	6.2%
6	2380	6.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	567916	80.6%
Common	136314	19.4%

Value	Count	Frequency (%)
Latin	155220	80.2%
Common	38370	19.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
M	62637	11.0%
Z	47777	8.4%
A	41249	7.3%
L	40895	7.2%
W	35262	6.2%
G	32352	5.7%
P	29018	5.1%
N	27928	4.9%
B	26003	4.6%
D	21524	3.8%
Other values (16)	203271	35.8%

Value	Count	Frequency (%)
M	16536	10.7%
Z	13193	8.5%
A	11705	7.5%
L	11297	7.3%
W	9959	6.4%
G	9016	5.8%
B	8130	5.2%
P	7863	5.1%
N	6016	3.9%
D	5933	3.8%
Other values (16)	55572	35.8%

Common

Value	Count	Frequency (%)
2	35577	26.1%
5	21034	15.4%
1	15557	11.4%
9	10751	7.9%
3	9209	6.8%
0	9038	6.6%
4	8937	6.6%
7	8795	6.5%
8	8772	6.4%
6	8644	6.3%

Value	Count	Frequency (%)
2	9278	24.2%
5	6315	16.5%
1	4776	12.4%
9	3162	8.2%
3	2640	6.9%
4	2507	6.5%
7	2475	6.5%
8	2439	6.4%
0	2398	6.2%
6	2380	6.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	704230	100.0%

Value	Count	Frequency (%)
ASCII	193590	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
M	62637	8.9%
Z	47777	6.8%
A	41249	5.9%
L	40895	5.8%
2	35577	5.1%
W	35262	5.0%
G	32352	4.6%
P	29018	4.1%
N	27928	4.0%
B	26003	3.7%
Other values (26)	325532	46.2%

Value	Count	Frequency (%)
M	16536	8.5%
Z	13193	6.8%
A	11705	6.0%
L	11297	5.8%
W	9959	5.1%
2	9278	4.8%
G	9016	4.7%
B	8130	4.2%
P	7863	4.1%
5	6315	3.3%
Other values (26)	90298	46.6%

creation_date
Date

Distinct	45070
Distinct (%)	64.0%
Missing	0
Missing (%)	0.0%
Memory size	550.3 KiB

Minimum	2020-01-02 09:04:37
Maximum	2024-09-30 18:10:26
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

modification_date
Date

Distinct	37979
Distinct (%)	61.6%
Missing	8751
Missing (%)	12.4%
Memory size	550.3 KiB

Minimum	2020-01-03 07:32:48
Maximum	2024-11-19 16:30:41
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

company_id
Real number (ℝ)

Distinct	3422
Distinct (%)	4.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1862.1276

Minimum	0
Maximum	8182
Zeros	354
Zeros (%)	0.5%
Negative	0
Negative (%)	0.0%
Memory size	619.1 KiB

Quantile statistics

Minimum	0
5-th percentile	61
Q1	293
median	743
Q3	3177
95-th percentile	6120.8
Maximum	8182
Range	8182
Interquartile range (IQR)	2884

Descriptive statistics

Standard deviation	2065.8092
Coefficient of variation (CV)	1.1093811
Kurtosis	0.10812841
Mean	1862.1276
Median Absolute Deviation (MAD)	676
Skewness	1.1124229
Sum	1.3113661 × 10⁸
Variance	4267567.6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
301	3940	5.6%
67	1662	2.4%
61	1372	1.9%
496	988	1.4%
7	968	1.4%
199	895	1.3%
654	815	1.2%
363	766	1.1%
494	753	1.1%
234	718	1.0%
Other values (3412)	57546	81.7%

Value	Count	Frequency (%)
0	354	0.5%
7	968	1.4%
14	17	< 0.1%
15	93	0.1%
16	492	0.7%
21	5	< 0.1%
28	1	< 0.1%
29	12	< 0.1%
30	2	< 0.1%
31	268	0.4%

Value	Count	Frequency (%)
8182	1	< 0.1%
8181	1	< 0.1%
8179	2	< 0.1%
8174	1	< 0.1%
8173	1	< 0.1%
8166	3	< 0.1%
8165	1	< 0.1%
8164	1	< 0.1%
8163	1	< 0.1%
8158	1	< 0.1%

user_id
Real number (ℝ)

Distinct	4172
Distinct (%)	5.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3612.2618

Minimum	2
Maximum	10939
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	619.1 KiB

Quantile statistics

Minimum	2
5-th percentile	118
Q1	670
median	3308
Q3	5894
95-th percentile	8852
Maximum	10939
Range	10937
Interquartile range (IQR)	5224

Descriptive statistics

Standard deviation	2903.7748
Coefficient of variation (CV)	0.80386611
Kurtosis	-0.86498309
Mean	3612.2618
Median Absolute Deviation (MAD)	2602
Skewness	0.48607415
Sum	2.5438631 × 10⁸
Variance	8431908.4
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3656	2709	3.8%
110	1372	1.9%
136	988	1.4%
1531	895	1.3%
4168	870	1.2%
504	766	1.1%
145	753	1.1%
471	699	1.0%
7604	675	1.0%
4396	650	0.9%
Other values (4162)	60046	85.3%

Value	Count	Frequency (%)
2	5	< 0.1%
3	4	< 0.1%
25	72	0.1%
29	7	< 0.1%
59	5	< 0.1%
69	13	< 0.1%
70	1	< 0.1%
71	11	< 0.1%
72	2	< 0.1%
73	268	0.4%

Value	Count	Frequency (%)
10939	1	< 0.1%
10938	1	< 0.1%
10936	2	< 0.1%
10931	1	< 0.1%
10930	1	< 0.1%
10923	3	< 0.1%
10922	1	< 0.1%
10921	1	< 0.1%
10920	1	< 0.1%
10915	1	< 0.1%

ref_cliente
Text

Distinct	37717
Distinct (%)	53.6%
Missing	13
Missing (%)	< 0.1%
Memory size	5.3 MiB

Length

Max length	75
Median length	68
Mean length	16.746087
Min length	1

Characters and Unicode

Total characters	1179092
Distinct characters	131
Distinct categories	16 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	27232 ?
Unique (%)	38.7%

Sample

1st row	PAL190646
2nd row	PAL190646
3rd row	CAMBIO TERMOSTATO LITE
4th row	PASARELAS SAMSUNG
5th row	PASARELAS SAMSUNG

Value	Count	Frequency (%)
	9774	6.3%
sav	2549	1.7%
renove	2052	1.3%
cf	1441	0.9%
cc	1303	0.8%
plan	1288	0.8%
reso	1068	0.7%
de	849	0.6%
clim	654	0.4%
pedido	653	0.4%
Other values (45834)	132397	86.0%

Most occurring characters

Value	Count	Frequency (%)
0	96652	8.2%
2	85369	7.2%
	85107	7.2%
1	62527	5.3%
A	51034	4.3%
E	49959	4.2%
3	48800	4.1%
4	39228	3.3%
C	38512	3.3%
S	34730	2.9%
Other values (121)	587174	49.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	472873	40.1%
Uppercase Letter	461673	39.2%
Lowercase Letter	105247	8.9%
Space Separator	85111	7.2%
Dash Punctuation	26635	2.3%
Other Punctuation	16892	1.4%
Other Symbol	3710	0.3%
Connector Punctuation	2941	0.2%
Open Punctuation	1305	0.1%
Close Punctuation	1265	0.1%
Other values (6)	1440	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	13236	12.6%
a	11839	11.2%
o	8413	8.0%
i	8143	7.7%
r	8116	7.7%
n	6858	6.5%
l	6697	6.4%
s	5694	5.4%
t	5541	5.3%
c	5165	4.9%
Other values (35)	25545	24.3%

Uppercase Letter

Value	Count	Frequency (%)
A	51034	11.1%
E	49959	10.8%
C	38512	8.3%
S	34730	7.5%
R	33994	7.4%
I	32768	7.1%
N	28715	6.2%
O	27863	6.0%
L	22479	4.9%
T	21780	4.7%
Other values (30)	119839	26.0%

Other Punctuation

Value	Count	Frequency (%)
/	9791	58.0%
.	3763	22.3%
,	1758	10.4%
*	454	2.7%
:	439	2.6%
'	212	1.3%
\	127	0.8%
&	90	0.5%
;	82	0.5%
#	51	0.3%
Other values (6)	125	0.7%

Decimal Number

Value	Count	Frequency (%)
0	96652	20.4%
2	85369	18.1%
1	62527	13.2%
3	48800	10.3%
4	39228	8.3%
6	31780	6.7%
5	29132	6.2%
7	27765	5.9%
8	26034	5.5%
9	25586	5.4%

Math Symbol

Value	Count	Frequency (%)
+	546	98.0%
\|	6	1.1%
<	3	0.5%
=	2	0.4%

Space Separator

Value	Count	Frequency (%)
	85107	> 99.9%
	4	< 0.1%

Open Punctuation

Value	Count	Frequency (%)
(	1301	99.7%
[	4	0.3%

Close Punctuation

Value	Count	Frequency (%)
)	1261	99.7%
]	4	0.3%

Other Letter

Value	Count	Frequency (%)
º	760	88.3%
ª	101	11.7%

Modifier Symbol

Value	Count	Frequency (%)
´	2	66.7%
`	1	33.3%

Dash Punctuation

Value	Count	Frequency (%)
-	26635	100.0%

Other Symbol

Value	Count	Frequency (%)
°	3710	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	2941	100.0%

Control

Value	Count	Frequency (%)
	14	100.0%

Format

Value	Count	Frequency (%)
	3	100.0%

Other Number

Value	Count	Frequency (%)
²	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	611312	51.8%
Latin	567780	48.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	51034	9.0%
E	49959	8.8%
C	38512	6.8%
S	34730	6.1%
R	33994	6.0%
I	32768	5.8%
N	28715	5.1%
O	27863	4.9%
L	22479	4.0%
T	21780	3.8%
Other values (76)	225946	39.8%

Common

Value	Count	Frequency (%)
0	96652	15.8%
2	85369	14.0%
	85107	13.9%
1	62527	10.2%
3	48800	8.0%
4	39228	6.4%
6	31780	5.2%
5	29132	4.8%
7	27765	4.5%
-	26635	4.4%
Other values (35)	78317	12.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1173190	99.5%
None	5902	0.5%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	96652	8.2%
2	85369	7.3%
	85107	7.3%
1	62527	5.3%
A	51034	4.4%
E	49959	4.3%
3	48800	4.2%
4	39228	3.3%
C	38512	3.3%
S	34730	3.0%
Other values (80)	581272	49.5%

None

Value	Count	Frequency (%)
°	3710	62.9%
º	760	12.9%
é	233	3.9%
Ó	200	3.4%
ó	165	2.8%
Ñ	156	2.6%
Í	102	1.7%
ª	101	1.7%
ñ	78	1.3%
Á	67	1.1%
Other values (31)	330	5.6%

portes_airzone
Text

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.9 MiB

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	70423
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Value	Count	Frequency (%)
1	66304	94.2%
0	4119	5.8%

Most occurring characters

Value	Count	Frequency (%)
1	66304	94.2%
0	4119	5.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	70423	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	66304	94.2%
0	4119	5.8%

Most occurring scripts

Value	Count	Frequency (%)
Common	70423	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	66304	94.2%
0	4119	5.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	70423	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	66304	94.2%
0	4119	5.8%

devaluacion
Text

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.9 MiB

Length

Max length	3
Median length	1
Mean length	1.0071852
Min length	1

Characters and Unicode

Total characters	70929
Distinct characters	9
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Value	Count	Frequency (%)
0	69918	99.3%
20	387	0.5%
30	45	0.1%
15	29	< 0.1%
10	21	< 0.1%
40	9	< 0.1%
25	4	< 0.1%
60	3	< 0.1%
50	3	< 0.1%
70	2	< 0.1%
Other values (2)	2	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	70391	99.2%
2	391	0.6%
1	50	0.1%
3	45	0.1%
5	37	0.1%
4	9	< 0.1%
6	3	< 0.1%
7	2	< 0.1%
8	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	70929	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	70391	99.2%
2	391	0.6%
1	50	0.1%
3	45	0.1%
5	37	0.1%
4	9	< 0.1%
6	3	< 0.1%
7	2	< 0.1%
8	1	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	70929	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	70391	99.2%
2	391	0.6%
1	50	0.1%
3	45	0.1%
5	37	0.1%
4	9	< 0.1%
6	3	< 0.1%
7	2	< 0.1%
8	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	70929	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	70391	99.2%
2	391	0.6%
1	50	0.1%
3	45	0.1%
5	37	0.1%
4	9	< 0.1%
6	3	< 0.1%
7	2	< 0.1%
8	1	< 0.1%

pedido_sage
Unsupported

Missing	70423
Missing (%)	100.0%
Memory size	550.3 KiB

abono_sage
Unsupported

Missing	70423
Missing (%)	100.0%
Memory size	550.3 KiB

pedido_a3
Text

Distinct	38409
Distinct (%)	63.3%
Missing	9730
Missing (%)	13.8%
Memory size	4.3 MiB

Length

Max length	60
Median length	8
Mean length	11.533043
Min length	1

Characters and Unicode

Total characters	699975
Distinct characters	88
Distinct categories	13 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	30849 ?
Unique (%)	50.8%

Sample

1st row	82000027 / 72000159
2nd row	82000027 / 72000159
3rd row	82000028/72000160
4th row	82000030
5th row	82000030

Value	Count	Frequency (%)
	747	1.1%
assistenze	313	0.5%
rma	305	0.5%
materiale	232	0.3%
cat	188	0.3%
82200355	146	0.2%
pack	145	0.2%
renove	110	0.2%
reso	108	0.2%
as06223697	95	0.1%
Other values (39470)	63932	96.4%

Most occurring characters

Value	Count	Frequency (%)
2	107823	15.4%
0	98705	14.1%
1	49742	7.1%
9	40210	5.7%
3	39873	5.7%
4	36779	5.3%
7	32360	4.6%
M	24891	3.6%
5	24330	3.5%
8	24013	3.4%
Other values (78)	221249	31.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	475637	68.0%
Uppercase Letter	190663	27.2%
Dash Punctuation	14672	2.1%
Lowercase Letter	6004	0.9%
Space Separator	5720	0.8%
Other Punctuation	5394	0.8%
Connector Punctuation	1675	0.2%
Math Symbol	121	< 0.1%
Open Punctuation	31	< 0.1%
Close Punctuation	31	< 0.1%
Other values (3)	27	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	819	13.6%
a	625	10.4%
i	612	10.2%
s	539	9.0%
r	518	8.6%
o	403	6.7%
n	378	6.3%
t	336	5.6%
d	277	4.6%
l	265	4.4%
Other values (22)	1232	20.5%

Uppercase Letter

Value	Count	Frequency (%)
M	24891	13.1%
A	23652	12.4%
R	20233	10.6%
E	10488	5.5%
Z	10131	5.3%
V	9706	5.1%
L	9324	4.9%
P	8129	4.3%
W	7160	3.8%
N	6604	3.5%
Other values (20)	60345	31.7%

Decimal Number

Value	Count	Frequency (%)
2	107823	22.7%
0	98705	20.8%
1	49742	10.5%
9	40210	8.5%
3	39873	8.4%
4	36779	7.7%
7	32360	6.8%
5	24330	5.1%
8	24013	5.0%
6	21802	4.6%

Other Punctuation

Value	Count	Frequency (%)
/	5157	95.6%
.	147	2.7%
,	69	1.3%
:	19	0.4%
'	2	< 0.1%

Math Symbol

Value	Count	Frequency (%)
+	117	96.7%
>	4	3.3%

Other Letter

Value	Count	Frequency (%)
º	18	94.7%
ª	1	5.3%

Dash Punctuation

Value	Count	Frequency (%)
-	14672	100.0%

Space Separator

Value	Count	Frequency (%)
	5720	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	1675	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	31	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	31	100.0%

Control

Value	Count	Frequency (%)
	4	100.0%

Other Symbol

Value	Count	Frequency (%)
°	4	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	503289	71.9%
Latin	196686	28.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
M	24891	12.7%
A	23652	12.0%
R	20233	10.3%
E	10488	5.3%
Z	10131	5.2%
V	9706	4.9%
L	9324	4.7%
P	8129	4.1%
W	7160	3.6%
N	6604	3.4%
Other values (54)	66368	33.7%

Common

Value	Count	Frequency (%)
2	107823	21.4%
0	98705	19.6%
1	49742	9.9%
9	40210	8.0%
3	39873	7.9%
4	36779	7.3%
7	32360	6.4%
5	24330	4.8%
8	24013	4.8%
6	21802	4.3%
Other values (14)	27652	5.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	699879	> 99.9%
None	96	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	107823	15.4%
0	98705	14.1%
1	49742	7.1%
9	40210	5.7%
3	39873	5.7%
4	36779	5.3%
7	32360	4.6%
M	24891	3.6%
5	24330	3.5%
8	24013	3.4%
Other values (65)	221153	31.6%

None

Value	Count	Frequency (%)
à	28	29.2%
ó	20	20.8%
º	18	18.8%
Ó	8	8.3%
Á	5	5.2%
Í	4	4.2%
°	4	4.2%
ñ	2	2.1%
è	2	2.1%
é	2	2.1%
Other values (3)	3	3.1%

abono_a3
Text

Distinct	20136
Distinct (%)	43.1%
Missing	23679
Missing (%)	33.6%
Memory size	3.7 MiB

Length

Max length	60
Median length	8
Mean length	8.8150351
Min length	1

Characters and Unicode

Total characters	412050
Distinct characters	76
Distinct categories	12 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	10048 ?
Unique (%)	21.5%

Sample

1st row	62000537
2nd row	62000398
3rd row	62000398
4th row	62000398
5th row	62000398

Value	Count	Frequency (%)
	1912	3.6%
fr	948	1.8%
alb	218	0.4%
fv	193	0.4%
ddt	157	0.3%
72300828	147	0.3%
72300168	97	0.2%
reg	79	0.1%
72400696	64	0.1%
72300047	61	0.1%
Other values (20158)	49340	92.7%

Most occurring characters

Value	Count	Frequency (%)
0	85418	20.7%
2	85300	20.7%
7	57221	13.9%
1	36564	8.9%
3	34844	8.5%
4	30700	7.5%
6	18674	4.5%
5	16325	4.0%
8	14127	3.4%
9	13965	3.4%
Other values (66)	18912	4.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	393138	95.4%
Space Separator	6597	1.6%
Uppercase Letter	6500	1.6%
Lowercase Letter	1985	0.5%
Other Punctuation	1633	0.4%
Dash Punctuation	1404	0.3%
Connector Punctuation	657	0.2%
Control	71	< 0.1%
Math Symbol	59	< 0.1%
Other Letter	2	< 0.1%
Other values (2)	4	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
R	1314	20.2%
F	1194	18.4%
E	556	8.6%
A	446	6.9%
G	417	6.4%
V	355	5.5%
D	350	5.4%
L	257	4.0%
N	256	3.9%
T	249	3.8%
Other values (16)	1106	17.0%

Lowercase Letter

Value	Count	Frequency (%)
a	274	13.8%
l	260	13.1%
e	249	12.5%
d	188	9.5%
b	166	8.4%
r	159	8.0%
o	100	5.0%
i	98	4.9%
g	95	4.8%
n	63	3.2%
Other values (15)	333	16.8%

Decimal Number

Value	Count	Frequency (%)
0	85418	21.7%
2	85300	21.7%
7	57221	14.6%
1	36564	9.3%
3	34844	8.9%
4	30700	7.8%
6	18674	4.7%
5	16325	4.2%
8	14127	3.6%
9	13965	3.6%

Other Punctuation

Value	Count	Frequency (%)
/	1326	81.2%
,	262	16.0%
.	19	1.2%
;	17	1.0%
?	5	0.3%
:	4	0.2%

Math Symbol

Value	Count	Frequency (%)
+	58	98.3%
>	1	1.7%

Space Separator

Value	Count	Frequency (%)
	6597	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1404	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	657	100.0%

Control

Value	Count	Frequency (%)
	71	100.0%

Other Letter

Value	Count	Frequency (%)
º	2	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	2	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	403563	97.9%
Latin	8487	2.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
R	1314	15.5%
F	1194	14.1%
E	556	6.6%
A	446	5.3%
G	417	4.9%
V	355	4.2%
D	350	4.1%
a	274	3.2%
l	260	3.1%
L	257	3.0%
Other values (42)	3064	36.1%

Common

Value	Count	Frequency (%)
0	85418	21.2%
2	85300	21.1%
7	57221	14.2%
1	36564	9.1%
3	34844	8.6%
4	30700	7.6%
6	18674	4.6%
5	16325	4.0%
8	14127	3.5%
9	13965	3.5%
Other values (14)	10425	2.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	412046	> 99.9%
None	4	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	85418	20.7%
2	85300	20.7%
7	57221	13.9%
1	36564	8.9%
3	34844	8.5%
4	30700	7.5%
6	18674	4.5%
5	16325	4.0%
8	14127	3.4%
9	13965	3.4%
Other values (63)	18908	4.6%

None

Value	Count	Frequency (%)
º	2	50.0%
ç	1	25.0%
ó	1	25.0%

tipo
Real number (ℝ)

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.4433211

Minimum	0
Maximum	3
Zeros	4
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	550.3 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	2
Maximum	3
Range	3
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.53171165
Coefficient of variation (CV)	0.36839457
Kurtosis	-0.91404197
Mean	1.4433211
Median Absolute Deviation (MAD)	0
Skewness	0.58297771
Sum	101643
Variance	0.28271728
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=4)

Value	Count	Frequency (%)
1	40456	57.4%
2	28702	40.8%
3	1261	1.8%
0	4	< 0.1%

Value	Count	Frequency (%)
0	4	< 0.1%
1	40456	57.4%
2	28702	40.8%
3	1261	1.8%

Value	Count	Frequency (%)
3	1261	1.8%
2	28702	40.8%
1	40456	57.4%
0	4	< 0.1%

estado
Real number (ℝ)

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.733908

Minimum	1
Maximum	76
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	550.3 KiB

Quantile statistics

Minimum	1
5-th percentile	6
Q1	6
median	6
Q3	6
95-th percentile	76
Maximum	76
Range	75
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	20.79176
Coefficient of variation (CV)	1.6327871
Kurtosis	5.3647795
Mean	12.733908
Median Absolute Deviation (MAD)	0
Skewness	2.7128909
Sum	896760
Variance	432.2973
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
6	60356	85.7%
76	6862	9.7%
4	2589	3.7%
5	526	0.7%
1	54	0.1%
2	36	0.1%

Value	Count	Frequency (%)
1	54	0.1%
2	36	0.1%
4	2589	3.7%
5	526	0.7%
6	60356	85.7%
76	6862	9.7%

Value	Count	Frequency (%)
76	6862	9.7%
6	60356	85.7%
5	526	0.7%
4	2589	3.7%
2	36	0.1%
1	54	0.1%

personaaz
Text

Distinct	25630
Distinct (%)	68.1%
Missing	32790
Missing (%)	46.6%
Memory size	3.4 MiB

Length

Max length	70
Median length	69
Mean length	7.7777217
Min length	1

Characters and Unicode

Total characters	292699
Distinct characters	102
Distinct categories	14 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	20767 ?
Unique (%)	55.2%

Sample

1st row	12459
2nd row	1042
3rd row	1042
4th row	1042
5th row	12664

Value	Count	Frequency (%)
ticket	1731	3.8%
dossier	730	1.6%
n°	712	1.6%
	450	1.0%
mario	400	0.9%
castillo	399	0.9%
eddy	273	0.6%
9998	247	0.5%
luis	232	0.5%
olivo	225	0.5%
Other values (25738)	39949	88.1%

Most occurring characters

Value	Count	Frequency (%)
0	39471	13.5%
2	31653	10.8%
1	25182	8.6%
4	24825	8.5%
3	23286	8.0%
9	17720	6.1%
5	16600	5.7%
7	16304	5.6%
8	15284	5.2%
6	15060	5.1%
Other values (92)	67314	23.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	225385	77.0%
Uppercase Letter	43437	14.8%
Lowercase Letter	11516	3.9%
Space Separator	7787	2.7%
Other Symbol	3346	1.1%
Other Punctuation	893	0.3%
Dash Punctuation	256	0.1%
Math Symbol	23	< 0.1%
Open Punctuation	15	< 0.1%
Close Punctuation	15	< 0.1%
Other values (4)	26	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1467	12.7%
t	1105	9.6%
i	1079	9.4%
a	894	7.8%
c	821	7.1%
o	785	6.8%
d	680	5.9%
n	665	5.8%
r	565	4.9%
k	458	4.0%
Other values (25)	2997	26.0%

Uppercase Letter

Value	Count	Frequency (%)
N	4844	11.2%
I	4430	10.2%
E	4349	10.0%
T	4010	9.2%
O	3661	8.4%
S	2996	6.9%
A	2898	6.7%
R	2695	6.2%
C	2522	5.8%
L	2143	4.9%
Other values (21)	8889	20.5%

Other Punctuation

Value	Count	Frequency (%)
*	246	27.5%
.	210	23.5%
/	183	20.5%
:	112	12.5%
?	68	7.6%
,	45	5.0%
'	11	1.2%
#	6	0.7%
·	3	0.3%
\	3	0.3%
Other values (5)	6	0.7%

Decimal Number

Value	Count	Frequency (%)
0	39471	17.5%
2	31653	14.0%
1	25182	11.2%
4	24825	11.0%
3	23286	10.3%
9	17720	7.9%
5	16600	7.4%
7	16304	7.2%
8	15284	6.8%
6	15060	6.7%

Math Symbol

Value	Count	Frequency (%)
+	22	95.7%
>	1	4.3%

Space Separator

Value	Count	Frequency (%)
	7787	100.0%

Other Symbol

Value	Count	Frequency (%)
°	3346	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	256	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	15	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	15	100.0%

Other Letter

Value	Count	Frequency (%)
º	10	100.0%

Control

Value	Count	Frequency (%)
	8	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	5	100.0%

Other Number

Value	Count	Frequency (%)
²	3	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	237736	81.2%
Latin	54963	18.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	4844	8.8%
I	4430	8.1%
E	4349	7.9%
T	4010	7.3%
O	3661	6.7%
S	2996	5.5%
A	2898	5.3%
R	2695	4.9%
C	2522	4.6%
L	2143	3.9%
Other values (57)	20415	37.1%

Common

Value	Count	Frequency (%)
0	39471	16.6%
2	31653	13.3%
1	25182	10.6%
4	24825	10.4%
3	23286	9.8%
9	17720	7.5%
5	16600	7.0%
7	16304	6.9%
8	15284	6.4%
6	15060	6.3%
Other values (25)	12351	5.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	289229	98.8%
None	3470	1.2%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	39471	13.6%
2	31653	10.9%
1	25182	8.7%
4	24825	8.6%
3	23286	8.1%
9	17720	6.1%
5	16600	5.7%
7	16304	5.6%
8	15284	5.3%
6	15060	5.2%
Other values (74)	63844	22.1%

None

Value	Count	Frequency (%)
°	3346	96.4%
é	75	2.2%
º	10	0.3%
Ñ	9	0.3%
è	4	0.1%
É	4	0.1%
·	3	0.1%
ú	3	0.1%
²	3	0.1%
ó	3	0.1%
Other values (8)	10	0.3%

dire_envio_id
Real number (ℝ)

Distinct	8696
Distinct (%)	20.2%
Missing	27434
Missing (%)	39.0%
Infinite	0
Infinite (%)	0.0%
Mean	8921.0796

Minimum	54
Maximum	23447
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	619.1 KiB

Quantile statistics

Minimum	54
5-th percentile	688
Q1	4511
median	7928
Q3	12453
95-th percentile	20516
Maximum	23447
Range	23393
Interquartile range (IQR)	7942

Descriptive statistics

Standard deviation	5958.7585
Coefficient of variation (CV)	0.66794142
Kurtosis	-0.51078463
Mean	8921.0796
Median Absolute Deviation (MAD)	3926
Skewness	0.55567263
Sum	3.8350829 × 10⁸
Variance	35506803
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10230	517	0.7%
5735	499	0.7%
9458	416	0.6%
7090	340	0.5%
2214	315	0.4%
4514	313	0.4%
6192	311	0.4%
4511	295	0.4%
2018	290	0.4%
2610	283	0.4%
Other values (8686)	39410	56.0%
(Missing)	27434	39.0%

Value	Count	Frequency (%)
54	1	< 0.1%
55	6	< 0.1%
59	79	0.1%
72	39	0.1%
80	11	< 0.1%
87	2	< 0.1%
100	3	< 0.1%
105	1	< 0.1%
147	4	< 0.1%
158	3	< 0.1%

Value	Count	Frequency (%)
23447	1	< 0.1%
23441	1	< 0.1%
23440	1	< 0.1%
23439	1	< 0.1%
23438	1	< 0.1%
23437	2	< 0.1%
23436	1	< 0.1%
23435	1	< 0.1%
23432	1	< 0.1%
23428	1	< 0.1%

dire_recogida_id
Real number (ℝ)

Distinct	5862
Distinct (%)	13.4%
Missing	26779
Missing (%)	38.0%
Infinite	0
Infinite (%)	0.0%
Mean	8295.192

Minimum	59
Maximum	24230
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	619.1 KiB

Quantile statistics

Minimum	59
5-th percentile	688
Q1	3082
median	7501.5
Q3	11833.25
95-th percentile	19735
Maximum	24230
Range	24171
Interquartile range (IQR)	8751.25

Descriptive statistics

Standard deviation	5836.2463
Coefficient of variation (CV)	0.70356977
Kurtosis	-0.45180512
Mean	8295.192
Median Absolute Deviation (MAD)	4381.5
Skewness	0.5793643
Sum	3.6203536 × 10⁸
Variance	34061771
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2018	1344	1.9%
844	714	1.0%
2214	634	0.9%
7090	506	0.7%
9458	460	0.7%
14000	428	0.6%
6192	411	0.6%
5741	385	0.5%
10345	343	0.5%
10230	327	0.5%
Other values (5852)	38092	54.1%
(Missing)	26779	38.0%

Value	Count	Frequency (%)
59	77	0.1%
72	54	0.1%
80	5	< 0.1%
87	3	< 0.1%
100	2	< 0.1%
105	3	< 0.1%
158	7	< 0.1%
160	31	< 0.1%
163	315	0.4%
166	1	< 0.1%

Value	Count	Frequency (%)
24230	1	< 0.1%
24198	1	< 0.1%
24017	1	< 0.1%
23998	2	< 0.1%
23845	1	< 0.1%
23830	1	< 0.1%
23797	1	< 0.1%
23743	1	< 0.1%
23742	1	< 0.1%
23728	1	< 0.1%

peso3
Real number (ℝ)

Distinct	495
Distinct (%)	1.2%
Missing	28236
Missing (%)	40.1%
Infinite	0
Infinite (%)	0.0%
Mean	9.0176633

Minimum	0.01
Maximum	200000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	550.3 KiB

Quantile statistics

Minimum	0.01
5-th percentile	0.32
Q1	1
median	1
Q3	3
95-th percentile	12.01
Maximum	200000
Range	199999.99
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	974.1464
Coefficient of variation (CV)	108.02648
Kurtosis	42112.133
Mean	9.0176633
Median Absolute Deviation (MAD)	0.5
Skewness	205.12259
Sum	380428.16
Variance	948961.21
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	15745	22.4%
2	6618	9.4%
3	3071	4.4%
0.5	3027	4.3%
5	2026	2.9%
1.5	1003	1.4%
4	812	1.2%
0.2	769	1.1%
10	736	1.0%
0.3	557	0.8%
Other values (485)	7823	11.1%
(Missing)	28236	40.1%

Value	Count	Frequency (%)
0.01	94	0.1%
0.02	7	< 0.1%
0.03	6	< 0.1%
0.04	3	< 0.1%
0.05	22	< 0.1%
0.06	1	< 0.1%
0.07	3	< 0.1%
0.1	244	0.3%
0.11	1	< 0.1%
0.111	1	< 0.1%

Value	Count	Frequency (%)
200000	1	< 0.1%
2130	2	< 0.1%
1752	5	< 0.1%
1060	1	< 0.1%
700	2	< 0.1%
500	4	< 0.1%
450	2	< 0.1%
400	2	< 0.1%
360	5	< 0.1%
342	7	< 0.1%

volumen3
Real number (ℝ)

Distinct	4
Distinct (%)	80.0%
Missing	70418
Missing (%)	> 99.9%
Infinite	0
Infinite (%)	0.0%
Mean	55101534

Minimum	7200571
Maximum	72200409
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	550.3 KiB

Quantile statistics

Minimum	7200571
5-th percentile	18160983
Q1	62002632
median	62002632
Q3	72101427
95-th percentile	72180613
Maximum	72200409
Range	64999838
Interquartile range (IQR)	10098795

Descriptive statistics

Standard deviation	27253993
Coefficient of variation (CV)	0.49461404
Kurtosis	4.3211375
Mean	55101534
Median Absolute Deviation (MAD)	10098795
Skewness	-2.0446544
Sum	2.7550767 × 10⁸
Variance	7.4278011 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=4)

Value	Count	Frequency (%)
62002632	2	< 0.1%
72101427	1	< 0.1%
72200409	1	< 0.1%
7200571	1	< 0.1%
(Missing)	70418	> 99.9%

Value	Count	Frequency (%)
7200571	1	< 0.1%
62002632	2	< 0.1%
72101427	1	< 0.1%
72200409	1	< 0.1%

Value	Count	Frequency (%)
72200409	1	< 0.1%
72101427	1	< 0.1%
62002632	2	< 0.1%
7200571	1	< 0.1%

estadofr
Real number (ℝ)

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.4759667

Minimum	0
Maximum	44
Zeros	8624
Zeros (%)	12.2%
Negative	0
Negative (%)	0.0%
Memory size	619.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	1
Q3	4
95-th percentile	43
Maximum	44
Range	44
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	12.408866
Coefficient of variation (CV)	1.9161412
Kurtosis	3.6285232
Mean	6.4759667
Median Absolute Deviation (MAD)	1
Skewness	2.3056026
Sum	456057
Variance	153.97996
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
1	33715	47.9%
4	16371	23.2%
0	8624	12.2%
43	4043	5.7%
38	1350	1.9%
40	929	1.3%
25	902	1.3%
5	847	1.2%
37	764	1.1%
3	569	0.8%
Other values (21)	2309	3.3%

Value	Count	Frequency (%)
0	8624	12.2%
1	33715	47.9%
2	222	0.3%
3	569	0.8%
4	16371	23.2%
5	847	1.2%
6	462	0.7%
7	20	< 0.1%
9	13	< 0.1%
10	10	< 0.1%

Value	Count	Frequency (%)
44	1	< 0.1%
43	4043	5.7%
42	215	0.3%
41	30	< 0.1%
40	929	1.3%
39	135	0.2%
38	1350	1.9%
37	764	1.1%
26	1	< 0.1%
25	902	1.3%

c_mail
Text

Distinct	638
Distinct (%)	22.5%
Missing	67591
Missing (%)	96.0%
Memory size	2.3 MiB

Length

Max length	46
Median length	36
Mean length	23.868291
Min length	2

Characters and Unicode

Total characters	67595
Distinct characters	74
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	355 ?
Unique (%)	12.5%

Sample

1st row	rdorde@airzonefrance.fr
2nd row	t.ramos@suministradora.com
3rd row	t.ramos@suministradora.com
4th row	guillaume.druelle@dalkia.fr
5th row	guillaume.druelle@dalkia.fr

Value	Count	Frequency (%)
eaunette@airzonefrance.fr	385	13.4%
pjmorales@airzone.es	104	3.6%
t.ramos@suministradora.com	90	3.1%
ruth.formigo@sonepar.es	90	3.1%
cfernandez@airzone.es	78	2.7%
juandaniel.padilla@sonepar.es	75	2.6%
abermudo@airzone.es	74	2.6%
jscapiali@airzonefrance.fr	74	2.6%
rdorde@airzonefrance.fr	70	2.4%
gabriel.carrillo@sonepar.es	60	2.1%
Other values (606)	1771	61.7%

Most occurring characters

Value	Count	Frequency (%)
a	5822	8.6%
e	5362	7.9%
r	5245	7.8%
o	4989	7.4%
i	4200	6.2%
n	4069	6.0%
.	3472	5.1%
c	3019	4.5%
@	2814	4.2%
s	2798	4.1%
Other values (64)	25805	38.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	51296	75.9%
Uppercase Letter	9642	14.3%
Other Punctuation	6293	9.3%
Decimal Number	234	0.3%
Dash Punctuation	70	0.1%
Space Separator	39	0.1%
Math Symbol	20	< 0.1%
Connector Punctuation	1	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	5822	11.3%
e	5362	10.5%
r	5245	10.2%
o	4989	9.7%
i	4200	8.2%
n	4069	7.9%
c	3019	5.9%
s	2798	5.5%
m	2610	5.1%
l	2317	4.5%
Other values (20)	10865	21.2%

Uppercase Letter

Value	Count	Frequency (%)
E	1774	18.4%
R	1036	10.7%
A	1005	10.4%
N	1003	10.4%
O	659	6.8%
I	581	6.0%
C	535	5.5%
F	503	5.2%
T	494	5.1%
S	347	3.6%
Other values (15)	1705	17.7%

Decimal Number

Value	Count	Frequency (%)
0	56	23.9%
1	53	22.6%
2	40	17.1%
3	20	8.5%
7	18	7.7%
8	14	6.0%
6	10	4.3%
5	10	4.3%
4	9	3.8%
9	4	1.7%

Other Punctuation

Value	Count	Frequency (%)
.	3472	55.2%
@	2814	44.7%
;	6	0.1%
,	1	< 0.1%

Math Symbol

Value	Count	Frequency (%)
<	10	50.0%
>	10	50.0%

Dash Punctuation

Value	Count	Frequency (%)
-	70	100.0%

Space Separator

Value	Count	Frequency (%)
	39	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	60938	90.2%
Common	6657	9.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	5822	9.6%
e	5362	8.8%
r	5245	8.6%
o	4989	8.2%
i	4200	6.9%
n	4069	6.7%
c	3019	5.0%
s	2798	4.6%
m	2610	4.3%
l	2317	3.8%
Other values (45)	20507	33.7%

Common

Value	Count	Frequency (%)
.	3472	52.2%
@	2814	42.3%
-	70	1.1%
0	56	0.8%
1	53	0.8%
2	40	0.6%
	39	0.6%
3	20	0.3%
7	18	0.3%
8	14	0.2%
Other values (9)	61	0.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	67574	> 99.9%
None	21	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	5822	8.6%
e	5362	7.9%
r	5245	7.8%
o	4989	7.4%
i	4200	6.2%
n	4069	6.0%
.	3472	5.1%
c	3019	4.5%
@	2814	4.2%
s	2798	4.1%
Other values (60)	25784	38.2%

None

Value	Count	Frequency (%)
ñ	9	42.9%
ú	8	38.1%
é	3	14.3%
á	1	4.8%

c_tel
Text

Distinct	909
Distinct (%)	28.2%
Missing	67202
Missing (%)	95.4%
Memory size	2.3 MiB

Length

Max length	38
Median length	33
Mean length	10.616889
Min length	1

Characters and Unicode

Total characters	34197
Distinct characters	71
Distinct categories	10 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	558 ?
Unique (%)	17.3%

Sample

1st row	0684541105
2nd row	937206363
3rd row	937206363
4th row	629 03 09 16
5th row	610 403 103

Value	Count	Frequency (%)
0631683163	356	7.3%
961223300	159	3.3%
683242387	149	3.1%
687805455	128	2.6%
937206363	106	2.2%
0680849660	76	1.6%
0684541105	70	1.4%
79	70	1.4%
680479813	69	1.4%
667	63	1.3%
Other values (988)	3636	74.5%

Most occurring characters

Value	Count	Frequency (%)
6	4897	14.3%
0	3333	9.7%
3	3330	9.7%
8	2820	8.2%
2	2356	6.9%
1	2308	6.7%
7	2159	6.3%
5	2149	6.3%
9	1956	5.7%
4	1790	5.2%
Other values (61)	7099	20.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	27098	79.2%
Uppercase Letter	5020	14.7%
Space Separator	1671	4.9%
Lowercase Letter	235	0.7%
Other Punctuation	124	0.4%
Math Symbol	39	0.1%
Open Punctuation	3	< 0.1%
Close Punctuation	3	< 0.1%
Dash Punctuation	3	< 0.1%
Connector Punctuation	1	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	711	14.2%
E	515	10.3%
O	499	9.9%
N	450	9.0%
R	434	8.6%
I	377	7.5%
L	261	5.2%
D	251	5.0%
S	232	4.6%
U	179	3.6%
Other values (17)	1111	22.1%

Lowercase Letter

Value	Count	Frequency (%)
a	33	14.0%
e	30	12.8%
r	23	9.8%
o	17	7.2%
i	15	6.4%
u	13	5.5%
l	12	5.1%
x	12	5.1%
s	11	4.7%
n	10	4.3%
Other values (13)	59	25.1%

Decimal Number

Value	Count	Frequency (%)
6	4897	18.1%
0	3333	12.3%
3	3330	12.3%
8	2820	10.4%
2	2356	8.7%
1	2308	8.5%
7	2159	8.0%
5	2149	7.9%
9	1956	7.2%
4	1790	6.6%

Other Punctuation

Value	Count	Frequency (%)
.	110	88.7%
/	12	9.7%
:	1	0.8%
@	1	0.8%

Space Separator

Value	Count	Frequency (%)
	1660	99.3%
	11	0.7%

Math Symbol

Value	Count	Frequency (%)
+	39	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	3	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	3	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	3	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	28942	84.6%
Latin	5255	15.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	711	13.5%
E	515	9.8%
O	499	9.5%
N	450	8.6%
R	434	8.3%
I	377	7.2%
L	261	5.0%
D	251	4.8%
S	232	4.4%
U	179	3.4%
Other values (40)	1346	25.6%

Common

Value	Count	Frequency (%)
6	4897	16.9%
0	3333	11.5%
3	3330	11.5%
8	2820	9.7%
2	2356	8.1%
1	2308	8.0%
7	2159	7.5%
5	2149	7.4%
9	1956	6.8%
4	1790	6.2%
Other values (11)	1844	6.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	34180	> 99.9%
None	17	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
6	4897	14.3%
0	3333	9.8%
3	3330	9.7%
8	2820	8.3%
2	2356	6.9%
1	2308	6.8%
7	2159	6.3%
5	2149	6.3%
9	1956	5.7%
4	1790	5.2%
Other values (58)	7082	20.7%

None

Value	Count	Frequency (%)
	11	64.7%
Ñ	3	17.6%
ñ	3	17.6%

c_obs
Text

Distinct	1067
Distinct (%)	48.7%
Missing	68233
Missing (%)	96.9%
Memory size	2.6 MiB

Length

Max length	2219
Median length	488
Mean length	121.13151
Min length	1

Characters and Unicode

Total characters	265278
Distinct characters	114
Distinct categories	14 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	718 ?
Unique (%)	32.8%

Sample

1st row	RAS
2nd row	TERMOSTATO EN GARANTIA NO FUNCIONA --
3rd row	TERMOSTATO NO FUNCIONA, MATERIAL EN GARANTIA --
4th row	QUANTITE A ENVOYER 2 X AZZS6IBPRO6E 2 X AZX6010VOLTZ
5th row	QUANTITE A ENVOYER 2 X AZZS6IBPRO6E 2 X AZX6010VOLTZ

Value	Count	Frequency (%)
de	1371	3.2%
se	1229	2.9%
	1177	2.7%
que	987	2.3%
en	943	2.2%
a	843	2.0%
el	827	1.9%
y	746	1.7%
por	660	1.5%
la	648	1.5%
Other values (4777)	33408	78.0%

Most occurring characters

Value	Count	Frequency (%)
	39062	14.7%
E	17966	6.8%
A	17049	6.4%
O	11620	4.4%
R	10117	3.8%
N	9749	3.7%
I	9359	3.5%
L	7585	2.9%
C	7357	2.8%
0	7117	2.7%
Other values (104)	128297	48.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	141427	53.3%
Lowercase Letter	52032	19.6%
Space Separator	39065	14.7%
Decimal Number	18722	7.1%
Control	6815	2.6%
Other Punctuation	5394	2.0%
Dash Punctuation	949	0.4%
Open Punctuation	296	0.1%
Close Punctuation	286	0.1%
Math Symbol	126	< 0.1%
Other values (4)	166	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	7005	13.5%
a	5576	10.7%
o	4161	8.0%
r	4068	7.8%
n	3924	7.5%
i	3688	7.1%
l	3183	6.1%
s	2747	5.3%
t	2682	5.2%
d	2236	4.3%
Other values (27)	12762	24.5%

Uppercase Letter

Value	Count	Frequency (%)
E	17966	12.7%
A	17049	12.1%
O	11620	8.2%
R	10117	7.2%
N	9749	6.9%
I	9359	6.6%
L	7585	5.4%
C	7357	5.2%
S	7060	5.0%
D	6677	4.7%
Other values (25)	36888	26.1%

Other Punctuation

Value	Count	Frequency (%)
,	2348	43.5%
.	2075	38.5%
:	319	5.9%
'	224	4.2%
/	97	1.8%
?	96	1.8%
*	95	1.8%
\	44	0.8%
%	25	0.5%
@	22	0.4%
Other values (5)	49	0.9%

Decimal Number

Value	Count	Frequency (%)
0	7117	38.0%
1	2850	15.2%
2	2386	12.7%
6	1447	7.7%
5	1069	5.7%
3	958	5.1%
4	825	4.4%
9	752	4.0%
8	720	3.8%
7	598	3.2%

Math Symbol

Value	Count	Frequency (%)
+	94	74.6%
>	22	17.5%
<	8	6.3%
=	1	0.8%
\|	1	0.8%

Control

Value	Count	Frequency (%)
	3209	47.1%
	3209	47.1%
	397	5.8%

Space Separator

Value	Count	Frequency (%)
	39062	> 99.9%
	3	< 0.1%

Dash Punctuation

Value	Count	Frequency (%)
-	949	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	296	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	286	100.0%

Other Letter

Value	Count	Frequency (%)
º	123	100.0%

Other Symbol

Value	Count	Frequency (%)
°	38	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	4	100.0%

Modifier Symbol

Value	Count	Frequency (%)
´	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	193582	73.0%
Common	71696	27.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	17966	9.3%
A	17049	8.8%
O	11620	6.0%
R	10117	5.2%
N	9749	5.0%
I	9359	4.8%
L	7585	3.9%
C	7357	3.8%
S	7060	3.6%
e	7005	3.6%
Other values (63)	88715	45.8%

Common

Value	Count	Frequency (%)
	39062	54.5%
0	7117	9.9%
	3209	4.5%
	3209	4.5%
1	2850	4.0%
2	2386	3.3%
,	2348	3.3%
.	2075	2.9%
6	1447	2.0%
5	1069	1.5%
Other values (31)	6924	9.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	263944	99.5%
None	1334	0.5%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	39062	14.8%
E	17966	6.8%
A	17049	6.5%
O	11620	4.4%
R	10117	3.8%
N	9749	3.7%
I	9359	3.5%
L	7585	2.9%
C	7357	2.8%
0	7117	2.7%
Other values (78)	126963	48.1%

None

Value	Count	Frequency (%)
é	481	36.1%
Ó	153	11.5%
ó	148	11.1%
º	123	9.2%
í	80	6.0%
à	52	3.9%
Ñ	49	3.7%
á	47	3.5%
Í	39	2.9%
°	38	2.8%
Other values (16)	124	9.3%

accepted_client
Text

Distinct	2
Distinct (%)	< 0.1%
Missing	62173
Missing (%)	88.3%
Memory size	2.4 MiB

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	66000
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	accepted
2nd row	accepted
3rd row	notified
4th row	notified
5th row	notified

Value	Count	Frequency (%)
accepted	5979	72.5%
notified	2271	27.5%

Most occurring characters

Value	Count	Frequency (%)
e	14229	21.6%
c	11958	18.1%
t	8250	12.5%
d	8250	12.5%
a	5979	9.1%
p	5979	9.1%
i	4542	6.9%
n	2271	3.4%
o	2271	3.4%
f	2271	3.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	66000	100.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	14229	21.6%
c	11958	18.1%
t	8250	12.5%
d	8250	12.5%
a	5979	9.1%
p	5979	9.1%
i	4542	6.9%
n	2271	3.4%
o	2271	3.4%
f	2271	3.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	66000	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	14229	21.6%
c	11958	18.1%
t	8250	12.5%
d	8250	12.5%
a	5979	9.1%
p	5979	9.1%
i	4542	6.9%
n	2271	3.4%
o	2271	3.4%
f	2271	3.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	66000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	14229	21.6%
c	11958	18.1%
t	8250	12.5%
d	8250	12.5%
a	5979	9.1%
p	5979	9.1%
i	4542	6.9%
n	2271	3.4%
o	2271	3.4%
f	2271	3.4%

desc_problema
Text

Distinct	35485
Distinct (%)	54.0%
Missing	4741
Missing (%)	6.7%
Memory size	11.8 MiB

Length

Max length	500
Median length	458
Mean length	76.620566
Min length	1

Characters and Unicode

Total characters	5032592
Distinct characters	149
Distinct categories	17 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	26437 ?
Unique (%)	40.2%

Sample

1st row	Solicitamos cambio de termostatos cables a termostatos inalámbricos.
2nd row	Solicitamos cambio de termostatos cables a termostatos inalámbricos.
3rd row	NECESITAMOS QUE NOS ENVIEN 1 TERMOSTATO AZRA6LITERB, NO HAY POSIBLILIDAD DE PONERLO CABLE
4th row	SE REALIZA MYZONE TRAS CONSULTAR A CARLOS FERNANDEZ. APARECEN EN EL INVENTARIO ESTAS PASARELAS QUE SE HAN PEDIDO POR ERROR.
5th row	SE REALIZA MYZONE TRAS CONSULTAR A CARLOS FERNANDEZ. APARECEN EN EL INVENTARIO ESTAS PASARELAS QUE SE HAN PEDIDO POR ERROR.

Value	Count	Frequency (%)
de	32333	4.1%
la	17266	2.2%
el	14448	1.8%
no	13188	1.7%
en	12768	1.6%
se	11316	1.4%
que	10942	1.4%
y	10933	1.4%
	10859	1.4%
por	8674	1.1%
Other values (40290)	647129	81.9%

Most occurring characters

Value	Count	Frequency (%)
	711823	14.1%
e	278695	5.5%
E	234207	4.7%
a	207341	4.1%
A	199227	4.0%
o	180423	3.6%
n	158031	3.1%
O	154969	3.1%
i	148822	3.0%
r	145147	2.9%
Other values (139)	2613907	51.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2061385	41.0%
Uppercase Letter	1838341	36.5%
Space Separator	711833	14.1%
Decimal Number	254139	5.0%
Other Punctuation	79458	1.6%
Control	60185	1.2%
Dash Punctuation	9276	0.2%
Open Punctuation	4408	0.1%
Close Punctuation	4345	0.1%
Other Symbol	4078	0.1%
Other values (7)	5144	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	278695	13.5%
a	207341	10.1%
o	180423	8.8%
n	158031	7.7%
i	148822	7.2%
r	145147	7.0%
t	129243	6.3%
s	124784	6.1%
l	117440	5.7%
c	91850	4.5%
Other values (38)	479609	23.3%

Uppercase Letter

Value	Count	Frequency (%)
E	234207	12.7%
A	199227	10.8%
O	154969	8.4%
N	140570	7.6%
R	129571	7.0%
I	126667	6.9%
T	108108	5.9%
S	104269	5.7%
L	100892	5.5%
C	91479	5.0%
Other values (36)	448382	24.4%

Other Punctuation

Value	Count	Frequency (%)
.	35996	45.3%
,	20703	26.1%
/	6583	8.3%
:	5543	7.0%
'	5272	6.6%
\	1955	2.5%
?	1399	1.8%
"	665	0.8%
*	390	0.5%
;	235	0.3%
Other values (8)	717	0.9%

Decimal Number

Value	Count	Frequency (%)
0	52659	20.7%
2	45526	17.9%
1	38393	15.1%
3	22716	8.9%
6	22230	8.7%
4	19869	7.8%
5	16756	6.6%
8	12869	5.1%
7	12089	4.8%
9	11032	4.3%

Math Symbol

Value	Count	Frequency (%)
+	1507	74.6%
>	293	14.5%
=	164	8.1%
<	52	2.6%
\|	3	0.1%

Modifier Symbol

Value	Count	Frequency (%)
´	13	68.4%
`	4	21.1%
¨	1	5.3%
^	1	5.3%

Control

Value	Count	Frequency (%)
	29678	49.3%
	29661	49.3%
	846	1.4%

Space Separator

Value	Count	Frequency (%)
	711823	> 99.9%
	10	< 0.1%

Open Punctuation

Value	Count	Frequency (%)
(	4399	99.8%
[	9	0.2%

Close Punctuation

Value	Count	Frequency (%)
)	4337	99.8%
]	8	0.2%

Other Letter

Value	Count	Frequency (%)
º	1735	93.8%
ª	115	6.2%

Currency Symbol

Value	Count	Frequency (%)
£	1	50.0%
$	1	50.0%

Dash Punctuation

Value	Count	Frequency (%)
-	9276	100.0%

Other Symbol

Value	Count	Frequency (%)
°	4078	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	1211	100.0%

Initial Punctuation

Value	Count	Frequency (%)
«	22	100.0%

Final Punctuation

Value	Count	Frequency (%)
»	21	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3901576	77.5%
Common	1131016	22.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	278695	7.1%
E	234207	6.0%
a	207341	5.3%
A	199227	5.1%
o	180423	4.6%
n	158031	4.1%
O	154969	4.0%
i	148822	3.8%
r	145147	3.7%
N	140570	3.6%
Other values (86)	2054144	52.6%

Common

Value	Count	Frequency (%)
	711823	62.9%
0	52659	4.7%
2	45526	4.0%
1	38393	3.4%
.	35996	3.2%
	29678	2.6%
	29661	2.6%
3	22716	2.0%
6	22230	2.0%
,	20703	1.8%
Other values (43)	121631	10.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4981667	99.0%
None	50925	1.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	711823	14.3%
e	278695	5.6%
E	234207	4.7%
a	207341	4.2%
A	199227	4.0%
o	180423	3.6%
n	158031	3.2%
O	154969	3.1%
i	148822	3.0%
r	145147	2.9%
Other values (85)	2562982	51.4%

None

Value	Count	Frequency (%)
é	17293	34.0%
ó	7025	13.8%
°	4078	8.0%
Ó	3362	6.6%
è	3222	6.3%
í	3160	6.2%
á	2243	4.4%
à	1966	3.9%
º	1735	3.4%
ú	926	1.8%
Other values (44)	5915	11.6%

codigo_incidencia
Text

Distinct	43757
Distinct (%)	63.4%
Missing	1426
Missing (%)	2.0%
Memory size	4.5 MiB

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	689970
Distinct characters	36
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	35299 ?
Unique (%)	51.2%

Sample

1st row	MGHQM2LT55
2nd row	MGHQM2LT55
3rd row	LMPOM2TR8B
4th row	LMNWLG1U1A
5th row	LMNWLG1U1A

Value	Count	Frequency (%)
bgvjymat77	146	0.2%
m5iwmzznd9	95	0.1%
m2dqbgdm0b	64	0.1%
am9pa21s32	60	0.1%
ljqcmz1m00	59	0.1%
b29ozmzv3e	57	0.1%
m5ebm5dj2f	57	0.1%
y2plz2ky3a	56	0.1%
k2lrmg5r5b	56	0.1%
njgel5plb9	50	0.1%
Other values (43747)	68297	99.0%

Most occurring characters

Value	Count	Frequency (%)
M	61365	8.9%
Z	46761	6.8%
A	40354	5.8%
L	40103	5.8%
2	34821	5.0%
W	34546	5.0%
G	31684	4.6%
P	28486	4.1%
N	27430	4.0%
B	25485	3.7%
Other values (26)	318935	46.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	556450	80.6%
Decimal Number	133520	19.4%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
M	61365	11.0%
Z	46761	8.4%
A	40354	7.3%
L	40103	7.2%
W	34546	6.2%
G	31684	5.7%
P	28486	5.1%
N	27430	4.9%
B	25485	4.6%
D	21131	3.8%
Other values (16)	199105	35.8%

Decimal Number

Value	Count	Frequency (%)
2	34821	26.1%
5	20600	15.4%
1	15264	11.4%
9	10554	7.9%
3	9019	6.8%
0	8864	6.6%
4	8753	6.6%
7	8605	6.4%
8	8587	6.4%
6	8453	6.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	556450	80.6%
Common	133520	19.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
M	61365	11.0%
Z	46761	8.4%
A	40354	7.3%
L	40103	7.2%
W	34546	6.2%
G	31684	5.7%
P	28486	5.1%
N	27430	4.9%
B	25485	4.6%
D	21131	3.8%
Other values (16)	199105	35.8%

Common

Value	Count	Frequency (%)
2	34821	26.1%
5	20600	15.4%
1	15264	11.4%
9	10554	7.9%
3	9019	6.8%
0	8864	6.6%
4	8753	6.6%
7	8605	6.4%
8	8587	6.4%
6	8453	6.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	689970	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
M	61365	8.9%
Z	46761	6.8%
A	40354	5.8%
L	40103	5.8%
2	34821	5.0%
W	34546	5.0%
G	31684	4.6%
P	28486	4.1%
N	27430	4.0%
B	25485	3.7%
Other values (26)	318935	46.2%

id_pieza
Real number (ℝ)

	Raw Dataset Profile	Preprocessed Dataset Profile
Distinct	68997	19359
Distinct (%)	100.0%	100.0%
Missing	1426	0
Missing (%)	2.0%	0.0%
Infinite	0	0
Infinite (%)	0.0%	0.0%
Mean	65749.77	58385.782

	Raw Dataset Profile	Preprocessed Dataset Profile
Minimum	29463	29479
Maximum	101854	93099
Zeros	0	0
Zeros (%)	0.0%	0.0%
Negative	0	0
Negative (%)	0.0%	0.0%
Memory size	619.1 KiB	170.3 KiB

Quantile statistics

	Raw Dataset Profile	Preprocessed Dataset Profile
Minimum	29463	29479
5-th percentile	33072.8	32675.7
Q1	47709	43363.5
median	65733	57214
Q3	83917	73007
95-th percentile	98274.2	87519
Maximum	101854	93099
Range	72391	63620
Interquartile range (IQR)	36208	29643.5

Descriptive statistics

	Raw Dataset Profile	Preprocessed Dataset Profile
Standard deviation	20904.22	17538.026
Coefficient of variation (CV)	0.31793602	0.30038179
Kurtosis	-1.1987341	-1.1380243
Mean	65749.77	58385.782
Median Absolute Deviation (MAD)	18104	14589
Skewness	-0.0040148951	0.17137332
Sum	4.5365369 × 10⁹	1.1302904 × 10⁹
Variance	4.3698642 × 10⁸	3.0758235 × 10⁸
Monotonicity	Not monotonic	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
77835	1	< 0.1%
77816	1	< 0.1%
77822	1	< 0.1%
77823	1	< 0.1%
77824	1	< 0.1%
77826	1	< 0.1%
77825	1	< 0.1%
77827	1	< 0.1%
77828	1	< 0.1%
77829	1	< 0.1%
Other values (68987)	68987	98.0%
(Missing)	1426	2.0%

Value	Count	Frequency (%)
29479	1	< 0.1%
67592	1	< 0.1%
67585	1	< 0.1%
67584	1	< 0.1%
67578	1	< 0.1%
67575	1	< 0.1%
67573	1	< 0.1%
67572	1	< 0.1%
67569	1	< 0.1%
67568	1	< 0.1%
Other values (19349)	19349	99.9%

Value	Count	Frequency (%)
29463	1	< 0.1%
29464	1	< 0.1%
29465	1	< 0.1%
29466	1	< 0.1%
29467	1	< 0.1%
29468	1	< 0.1%
29469	1	< 0.1%
29470	1	< 0.1%
29471	1	< 0.1%
29472	1	< 0.1%

Value	Count	Frequency (%)
29479	1	< 0.1%
29480	1	< 0.1%
29481	1	< 0.1%
29482	1	< 0.1%
29487	1	< 0.1%
29490	1	< 0.1%
29491	1	< 0.1%
29492	1	< 0.1%
29493	1	< 0.1%
29522	1	< 0.1%

Value	Count	Frequency (%)
29479	1	< 0.1%
29480	1	< 0.1%
29481	1	< 0.1%
29482	1	< 0.1%
29487	1	< 0.1%
29490	1	< 0.1%
29491	1	< 0.1%
29492	1	< 0.1%
29493	1	< 0.1%
29522	1	< 0.1%

Value	Count	Frequency (%)
29463	1	< 0.1%
29464	1	< 0.1%
29465	1	< 0.1%
29466	1	< 0.1%
29467	1	< 0.1%
29468	1	< 0.1%
29469	1	< 0.1%
29470	1	< 0.1%
29471	1	< 0.1%
29472	1	< 0.1%

user_id_pieza
Real number (ℝ)

Distinct	4169
Distinct (%)	6.0%
Missing	1426
Missing (%)	2.0%
Infinite	0
Infinite (%)	0.0%
Mean	3602.3952

Minimum	0
Maximum	10939
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	619.1 KiB

Quantile statistics

Minimum	0
5-th percentile	118
Q1	668
median	3299
Q3	5853
95-th percentile	8852
Maximum	10939
Range	10939
Interquartile range (IQR)	5185

Descriptive statistics

Standard deviation	2900.5
Coefficient of variation (CV)	0.80515874
Kurtosis	-0.85824229
Mean	3602.3952
Median Absolute Deviation (MAD)	2606
Skewness	0.49060378
Sum	2.4855446 × 10⁸
Variance	8412900.1
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3656	2694	3.8%
110	1369	1.9%
136	986	1.4%
1531	894	1.3%
4168	863	1.2%
504	753	1.1%
145	749	1.1%
471	696	1.0%
7604	675	1.0%
4396	648	0.9%
Other values (4159)	58670	83.3%
(Missing)	1426	2.0%

Value	Count	Frequency (%)
0	1	< 0.1%
2	5	< 0.1%
3	4	< 0.1%
25	71	0.1%
29	7	< 0.1%
59	5	< 0.1%
69	13	< 0.1%
70	1	< 0.1%
71	10	< 0.1%
72	2	< 0.1%

Value	Count	Frequency (%)
10939	1	< 0.1%
10938	1	< 0.1%
10936	2	< 0.1%
10931	1	< 0.1%
10930	1	< 0.1%
10923	1	< 0.1%
10922	1	< 0.1%
10921	1	< 0.1%
10920	1	< 0.1%
10915	1	< 0.1%

cod_articulo
['Text', 'Text']

	Raw Dataset Profile	Preprocessed Dataset Profile
Distinct	10609	2397
Distinct (%)	15.4%	12.4%
Missing	1435	0
Missing (%)	2.0%	0.0%
Memory size	4.6 MiB	1.3 MiB

Length

	Raw Dataset Profile	Preprocessed Dataset Profile
Max length	16	16
Median length	14	14
Mean length	11.706413	12.181776
Min length	1	1

Characters and Unicode

	Raw Dataset Profile	Preprocessed Dataset Profile
Total characters	807602	235827
Distinct characters	102	82
Distinct categories	15	14 ?
Distinct scripts	2	2 ?
Distinct blocks	2	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

	Raw Dataset Profile	Preprocessed Dataset Profile
Unique	7463	1606 ?
Unique (%)	10.8%	8.3%

Sample

	Raw Dataset Profile	Preprocessed Dataset Profile
1st row	AZCE6BLUEFACECB	AZXWSCLOUDWIFI
2nd row	AZCE6LITECB	AZX6QADAPTHIT
3rd row	AZRA6LITECB	AZX6QADAPTHIT
4th row	AZX6QADAPTSAM	AZX6CCP
5th row	AZX6QADAPTSAM	AZCE6EXP8Z

Value	Count	Frequency (%)
azce6thinkrb	5386	7.1%
azpv8cb1iaq	2470	3.3%
azce6bluefacecb	2349	3.1%
azce6bluezerocb	2049	2.7%
azx6wsc5ger	1773	2.3%
azce6flexa3	1086	1.4%
azx6wsphub	1074	1.4%
	1043	1.4%
azx6gtcda1	961	1.3%
azpv6cam200ion	894	1.2%
Other values (8837)	56782	74.8%

Value	Count	Frequency (%)
azce6thinkrb	1964	10.0%
azce6bluefacecb	1532	7.8%
azce6bluezerocb	755	3.8%
azx6wsc5ger	666	3.4%
azce6flexa3	573	2.9%
azpv8cb1iaq	497	2.5%
azdi6bluefacecb	385	2.0%
azce6thinkcb	363	1.8%
azx6gtcda1	358	1.8%
azpv6ac1ant	338	1.7%
Other values (2013)	12306	62.3%

Most occurring characters

Value	Count	Frequency (%)
A	81634	10.1%
C	61020	7.6%
Z	56923	7.0%
E	52644	6.5%
6	45282	5.6%
B	39558	4.9%
0	35064	4.3%
T	34702	4.3%
I	32471	4.0%
R	32174	4.0%
Other values (92)	336130	41.6%

Value	Count	Frequency (%)
A	26270	11.1%
C	22373	9.5%
Z	19186	8.1%
E	19083	8.1%
6	16791	7.1%
B	13842	5.9%
I	9780	4.1%
T	8505	3.6%
R	8175	3.5%
L	6371	2.7%
Other values (72)	85451	36.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	621036	76.9%
Decimal Number	136114	16.9%
Lowercase Letter	39069	4.8%
Space Separator	7792	1.0%
Other Punctuation	1876	0.2%
Dash Punctuation	1143	0.1%
Math Symbol	191	< 0.1%
Open Punctuation	131	< 0.1%
Connector Punctuation	91	< 0.1%
Close Punctuation	58	< 0.1%
Other values (5)	101	< 0.1%

Value	Count	Frequency (%)
Uppercase Letter	193030	81.9%
Decimal Number	32069	13.6%
Lowercase Letter	9899	4.2%
Space Separator	476	0.2%
Other Punctuation	138	0.1%
Dash Punctuation	114	< 0.1%
Math Symbol	44	< 0.1%
Open Punctuation	22	< 0.1%
Connector Punctuation	13	< 0.1%
Control	10	< 0.1%
Other values (4)	12	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	81634	13.1%
C	61020	9.8%
Z	56923	9.2%
E	52644	8.5%
B	39558	6.4%
T	34702	5.6%
I	32471	5.2%
R	32174	5.2%
N	23452	3.8%
O	22545	3.6%
Other values (19)	183913	29.6%

Value	Count	Frequency (%)
A	26270	13.6%
C	22373	11.6%
Z	19186	9.9%
E	19083	9.9%
B	13842	7.2%
I	9780	5.1%
T	8505	4.4%
R	8175	4.2%
L	6371	3.3%
N	6196	3.2%
Other values (16)	53249	27.6%

Decimal Number

Value	Count	Frequency (%)
6	45282	33.3%
0	35064	25.8%
1	18297	13.4%
5	8806	6.5%
2	8130	6.0%
3	7302	5.4%
8	7037	5.2%
4	3619	2.7%
7	1625	1.2%
9	952	0.7%

Value	Count	Frequency (%)
6	16791	52.4%
0	5198	16.2%
1	3646	11.4%
5	1627	5.1%
3	1591	5.0%
8	1545	4.8%
2	1114	3.5%
4	346	1.1%
7	195	0.6%
9	16	< 0.1%

Space Separator

Value	Count	Frequency (%)
	7788	99.9%
	4	0.1%

Value	Count	Frequency (%)
	476	100.0%

Lowercase Letter

Value	Count	Frequency (%)
a	4443	11.4%
e	4101	10.5%
c	3170	8.1%
z	2552	6.5%
t	2470	6.3%
r	2241	5.7%
i	2122	5.4%
n	1930	4.9%
b	1918	4.9%
o	1772	4.5%
Other values (25)	12350	31.6%

Value	Count	Frequency (%)
a	1278	12.9%
c	1100	11.1%
e	1031	10.4%
z	923	9.3%
b	730	7.4%
i	538	5.4%
r	475	4.8%
t	454	4.6%
n	363	3.7%
p	354	3.6%
Other values (17)	2653	26.8%

Dash Punctuation

Value	Count	Frequency (%)
-	1143	100.0%

Value	Count	Frequency (%)
-	114	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	643	34.3%
*	559	29.8%
/	328	17.5%
?	221	11.8%
:	85	4.5%
,	17	0.9%
\	5	0.3%
'	5	0.3%
%	5	0.3%
;	4	0.2%
Other values (2)	4	0.2%

Value	Count	Frequency (%)
?	58	42.0%
/	38	27.5%
.	24	17.4%
,	6	4.3%
*	5	3.6%
%	4	2.9%
:	3	2.2%

Math Symbol

Value	Count	Frequency (%)
+	188	98.4%
>	2	1.0%
<	1	0.5%

Value	Count	Frequency (%)
+	43	97.7%
<	1	2.3%

Open Punctuation

Value	Count	Frequency (%)
(	128	97.7%
[	3	2.3%

Value	Count	Frequency (%)
(	21	95.5%
[	1	4.5%

Connector Punctuation

Value	Count	Frequency (%)
_	91	100.0%

Value	Count	Frequency (%)
_	13	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	56	96.6%
]	2	3.4%

Value	Count	Frequency (%)
)	7	100.0%

Other Symbol

Value	Count	Frequency (%)
°	55	100.0%

Value	Count	Frequency (%)
°	2	100.0%

Control

Value	Count	Frequency (%)
	29	100.0%

Value	Count	Frequency (%)
	10	100.0%

Other Number

Value	Count	Frequency (%)
²	3	100.0%

Value	Count	Frequency (%)
²	2	100.0%

Modifier Symbol

Value	Count	Frequency (%)
¨	2	100.0%

Value	Count	Frequency (%)
¨	1	100.0%

Other Letter

Value	Count	Frequency (%)
º	12	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	660117	81.7%
Common	147485	18.3%

Value	Count	Frequency (%)
Latin	202929	86.0%
Common	32898	14.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	81634	12.4%
C	61020	9.2%
Z	56923	8.6%
E	52644	8.0%
B	39558	6.0%
T	34702	5.3%
I	32471	4.9%
R	32174	4.9%
N	23452	3.6%
O	22545	3.4%
Other values (55)	222994	33.8%

Value	Count	Frequency (%)
A	26270	12.9%
C	22373	11.0%
Z	19186	9.5%
E	19083	9.4%
B	13842	6.8%
I	9780	4.8%
T	8505	4.2%
R	8175	4.0%
L	6371	3.1%
N	6196	3.1%
Other values (43)	63148	31.1%

Common

Value	Count	Frequency (%)
6	45282	30.7%
0	35064	23.8%
1	18297	12.4%
5	8806	6.0%
2	8130	5.5%
	7788	5.3%
3	7302	5.0%
8	7037	4.8%
4	3619	2.5%
7	1625	1.1%
Other values (27)	4535	3.1%

Value	Count	Frequency (%)
6	16791	51.0%
0	5198	15.8%
1	3646	11.1%
5	1627	4.9%
3	1591	4.8%
8	1545	4.7%
2	1114	3.4%
	476	1.4%
4	346	1.1%
7	195	0.6%
Other values (19)	369	1.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	807406	> 99.9%
None	196	< 0.1%

Value	Count	Frequency (%)
ASCII	235820	> 99.9%
None	7	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	81634	10.1%
C	61020	7.6%
Z	56923	7.1%
E	52644	6.5%
6	45282	5.6%
B	39558	4.9%
0	35064	4.3%
T	34702	4.3%
I	32471	4.0%
R	32174	4.0%
Other values (75)	335934	41.6%

Value	Count	Frequency (%)
A	26270	11.1%
C	22373	9.5%
Z	19186	8.1%
E	19083	8.1%
6	16791	7.1%
B	13842	5.9%
I	9780	4.1%
T	8505	3.6%
R	8175	3.5%
L	6371	2.7%
Other values (68)	85444	36.2%

None

Value	Count	Frequency (%)
é	67	34.2%
°	55	28.1%
Ó	20	10.2%
ó	12	6.1%
º	12	6.1%
É	6	3.1%
è	5	2.6%
à	4	2.0%
	4	2.0%
²	3	1.5%
Other values (7)	8	4.1%

Value	Count	Frequency (%)
é	2	28.6%
²	2	28.6%
°	2	28.6%
¨	1	14.3%

descripcion
Text

Distinct	17027
Distinct (%)	33.5%
Missing	19536
Missing (%)	27.7%
Memory size	4.8 MiB

Length

Max length	50
Median length	36
Mean length	26.492817
Min length	1

Characters and Unicode

Total characters	1348140
Distinct characters	135
Distinct categories	17 ?
Distinct scripts	2 ?
Distinct blocks	4 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	12053 ?
Unique (%)	23.7%

Sample

1st row	TERMOSTATO BLUEFACE CABLE BLANCO
2nd row	TERMOSTATO LITE BLANCO CABLE
3rd row	TERMOSTATO LITE CABLE BLANCO
4th row	PASARELA SAMSUNG NO NASA
5th row	PASARELA SAMSUNG NO NASA

Value	Count	Frequency (%)
airzone	11960	6.3%
termostato	7723	4.0%
de	6156	3.2%
thermostat	4095	2.1%
radio	3965	2.1%
think	3872	2.0%
blueface	3826	2.0%
cable	3352	1.8%
rejilla	3303	1.7%
central	2984	1.6%
Other values (6654)	139636	73.2%

Most occurring characters

Value	Count	Frequency (%)
	141253	10.5%
E	100112	7.4%
A	90538	6.7%
O	79087	5.9%
T	71460	5.3%
R	69630	5.2%
I	58468	4.3%
L	52745	3.9%
N	50480	3.7%
C	42720	3.2%
Other values (125)	591647	43.9%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	852504	63.2%
Lowercase Letter	275589	20.4%
Space Separator	141264	10.5%
Decimal Number	61558	4.6%
Other Punctuation	9046	0.7%
Dash Punctuation	4197	0.3%
Open Punctuation	1458	0.1%
Close Punctuation	1089	0.1%
Math Symbol	1031	0.1%
Other Letter	330	< 0.1%
Other values (7)	74	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	38185	13.9%
a	26399	9.6%
o	25307	9.2%
r	23699	8.6%
i	20270	7.4%
t	20130	7.3%
n	19903	7.2%
l	17296	6.3%
c	12452	4.5%
m	11225	4.1%
Other values (34)	60723	22.0%

Uppercase Letter

Value	Count	Frequency (%)
E	100112	11.7%
A	90538	10.6%
O	79087	9.3%
T	71460	8.4%
R	69630	8.2%
I	58468	6.9%
L	52745	6.2%
N	50480	5.9%
C	42720	5.0%
S	33873	4.0%
Other values (31)	203391	23.9%

Other Punctuation

Value	Count	Frequency (%)
.	6272	69.3%
/	1448	16.0%
*	533	5.9%
,	397	4.4%
\	116	1.3%
'	86	1.0%
:	80	0.9%
?	51	0.6%
"	15	0.2%
&	12	0.1%
Other values (6)	36	0.4%

Decimal Number

Value	Count	Frequency (%)
0	21088	34.3%
2	7236	11.8%
1	7082	11.5%
6	6646	10.8%
3	6016	9.8%
5	5586	9.1%
8	4261	6.9%
4	2684	4.4%
7	657	1.1%
9	302	0.5%

Math Symbol

Value	Count	Frequency (%)
+	1013	98.3%
>	14	1.4%
<	3	0.3%
=	1	0.1%

Control

Value	Count	Frequency (%)
	8	66.7%
	2	16.7%
	2	16.7%

Space Separator

Value	Count	Frequency (%)
	141253	> 99.9%
	11	< 0.1%

Open Punctuation

Value	Count	Frequency (%)
(	1448	99.3%
[	10	0.7%

Close Punctuation

Value	Count	Frequency (%)
)	1083	99.4%
]	6	0.6%

Other Letter

Value	Count	Frequency (%)
º	327	99.1%
ª	3	0.9%

Currency Symbol

Value	Count	Frequency (%)
€	2	66.7%
$	1	33.3%

Modifier Symbol

Value	Count	Frequency (%)
´	1	50.0%
`	1	50.0%

Dash Punctuation

Value	Count	Frequency (%)
-	4197	100.0%

Other Symbol

Value	Count	Frequency (%)
°	41	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	13	100.0%

Initial Punctuation

Value	Count	Frequency (%)
“	2	100.0%

Other Number

Value	Count	Frequency (%)
²	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1128421	83.7%
Common	219719	16.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	100112	8.9%
A	90538	8.0%
O	79087	7.0%
T	71460	6.3%
R	69630	6.2%
I	58468	5.2%
L	52745	4.7%
N	50480	4.5%
C	42720	3.8%
e	38185	3.4%
Other values (76)	474996	42.1%

Common

Value	Count	Frequency (%)
	141253	64.3%
0	21088	9.6%
2	7236	3.3%
1	7082	3.2%
6	6646	3.0%
.	6272	2.9%
3	6016	2.7%
5	5586	2.5%
8	4261	1.9%
-	4197	1.9%
Other values (39)	10082	4.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1345511	99.8%
None	2625	0.2%
Punctuation	2	< 0.1%
Currency Symbols	2	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	141253	10.5%
E	100112	7.4%
A	90538	6.7%
O	79087	5.9%
T	71460	5.3%
R	69630	5.2%
I	58468	4.3%
L	52745	3.9%
N	50480	3.8%
C	42720	3.2%
Other values (80)	589018	43.8%

None

Value	Count	Frequency (%)
é	818	31.2%
Ó	419	16.0%
ó	341	13.0%
º	327	12.5%
Á	133	5.1%
è	97	3.7%
á	68	2.6%
â	63	2.4%
É	53	2.0%
Ø	44	1.7%
Other values (33)	262	10.0%

Punctuation

Value	Count	Frequency (%)
“	2	100.0%

Currency Symbols

Value	Count	Frequency (%)
€	2	100.0%

num_serie
Text

Distinct	35095
Distinct (%)	50.9%
Missing	1508
Missing (%)	2.1%
Memory size	4.2 MiB

Length

Max length	10
Median length	8
Mean length	6.3455561
Min length	1

Characters and Unicode

Total characters	437304
Distinct characters	101
Distinct categories	16 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	32409 ?
Unique (%)	47.0%

Sample

1st row	NO DISPONI
2nd row	NO DISPONI
3rd row	F00K2QH
4th row	00HJNZ
5th row	00LSS7

Value	Count	Frequency (%)
	9505	12.5%
no	2754	3.6%
xxxx	1583	2.1%
8435418928	1045	1.4%
0000	1032	1.4%
dispong	1016	1.3%
xxx	961	1.3%
ticket	901	1.2%
nc	816	1.1%
000000	766	1.0%
Other values (34539)	55559	73.2%

Most occurring characters

Value	Count	Frequency (%)
0	89916	20.6%
1	19930	4.6%
X	18336	4.2%
4	17323	4.0%
F	16442	3.8%
8	15057	3.4%
5	14752	3.4%
N	13072	3.0%
3	12523	2.9%
9	10676	2.4%
Other values (91)	209277	47.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	203892	46.6%
Uppercase Letter	182979	41.8%
Lowercase Letter	24403	5.6%
Other Punctuation	11049	2.5%
Space Separator	7521	1.7%
Dash Punctuation	6939	1.6%
Other Symbol	263	0.1%
Math Symbol	139	< 0.1%
Connector Punctuation	35	< 0.1%
Other Letter	31	< 0.1%
Other values (6)	53	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
x	5236	21.5%
n	2520	10.3%
o	1889	7.7%
i	1391	5.7%
e	1338	5.5%
s	1210	5.0%
c	1167	4.8%
t	1016	4.2%
d	963	3.9%
a	926	3.8%
Other values (24)	6747	27.6%

Uppercase Letter

Value	Count	Frequency (%)
X	18336	10.0%
F	16442	9.0%
N	13072	7.1%
C	10494	5.7%
A	10423	5.7%
D	8588	4.7%
I	8008	4.4%
E	7777	4.3%
O	7255	4.0%
S	7136	3.9%
Other values (20)	75448	41.2%

Other Punctuation

Value	Count	Frequency (%)
*	5234	47.4%
.	2466	22.3%
/	1862	16.9%
?	802	7.3%
:	439	4.0%
,	124	1.1%
;	45	0.4%
\	24	0.2%
'	20	0.2%
¿	14	0.1%
Other values (4)	19	0.2%

Decimal Number

Value	Count	Frequency (%)
0	89916	44.1%
1	19930	9.8%
4	17323	8.5%
8	15057	7.4%
5	14752	7.2%
3	12523	6.1%
9	10676	5.2%
2	10319	5.1%
6	7133	3.5%
7	6263	3.1%

Open Punctuation

Value	Count	Frequency (%)
(	23	95.8%
[	1	4.2%

Space Separator

Value	Count	Frequency (%)
	7521	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	6939	100.0%

Other Symbol

Value	Count	Frequency (%)
°	263	100.0%

Math Symbol

Value	Count	Frequency (%)
+	139	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	35	100.0%

Other Letter

Value	Count	Frequency (%)
º	31	100.0%

Control

Value	Count	Frequency (%)
	11	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	7	100.0%

Modifier Symbol

Value	Count	Frequency (%)
^	7	100.0%

Other Number

Value	Count	Frequency (%)
²	3	100.0%

Initial Punctuation

Value	Count	Frequency (%)
«	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	229899	52.6%
Latin	207405	47.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
X	18336	8.8%
F	16442	7.9%
N	13072	6.3%
C	10494	5.1%
A	10423	5.0%
D	8588	4.1%
I	8008	3.9%
E	7777	3.7%
O	7255	3.5%
S	7136	3.4%
Other values (54)	99874	48.2%

Common

Value	Count	Frequency (%)
0	89916	39.1%
1	19930	8.7%
4	17323	7.5%
8	15057	6.5%
5	14752	6.4%
3	12523	5.4%
9	10676	4.6%
2	10319	4.5%
	7521	3.3%
6	7133	3.1%
Other values (27)	24749	10.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	436839	99.9%
None	465	0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	89916	20.6%
1	19930	4.6%
X	18336	4.2%
4	17323	4.0%
F	16442	3.8%
8	15057	3.4%
5	14752	3.4%
N	13072	3.0%
3	12523	2.9%
9	10676	2.4%
Other values (73)	208812	47.8%

None

Value	Count	Frequency (%)
°	263	56.6%
é	61	13.1%
à	45	9.7%
º	31	6.7%
¿	14	3.0%
Ø	12	2.6%
ó	8	1.7%
µ	8	1.7%
Ó	6	1.3%
É	4	0.9%
Other values (8)	13	2.8%

factura_albaran
Text

Distinct	19710
Distinct (%)	48.9%
Missing	30101
Missing (%)	42.7%
Memory size	3.6 MiB

Length

Max length	60
Median length	58
Mean length	10.80254
Min length	1

Characters and Unicode

Total characters	435580
Distinct characters	108
Distinct categories	15 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	14677 ?
Unique (%)	36.4%

Sample

1st row	1/11912209
2nd row	1/11912209
3rd row	1/11916095
4th row	21805007
5th row	21405974

Value	Count	Frequency (%)
	3452	5.9%
no	1814	3.1%
dispongo	819	1.4%
00000	660	1.1%
xxxx	602	1.0%
albaran	518	0.9%
pedido	504	0.9%
del	485	0.8%
factura	468	0.8%
xxx	430	0.7%
Other values (22059)	48483	83.3%

Most occurring characters

Value	Count	Frequency (%)
2	64037	14.7%
0	53294	12.2%
1	47457	10.9%
3	23376	5.4%
4	20677	4.7%
	18610	4.3%
6	17280	4.0%
5	14773	3.4%
7	14725	3.4%
8	13949	3.2%
Other values (98)	147402	33.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	283201	65.0%
Uppercase Letter	86790	19.9%
Lowercase Letter	21473	4.9%
Other Punctuation	18889	4.3%
Space Separator	18610	4.3%
Dash Punctuation	5466	1.3%
Other Letter	346	0.1%
Other Symbol	229	0.1%
Connector Punctuation	219	0.1%
Open Punctuation	129	< 0.1%
Other values (5)	228	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	2314	10.8%
a	2099	9.8%
o	1767	8.2%
n	1758	8.2%
d	1564	7.3%
i	1497	7.0%
r	1301	6.1%
c	1197	5.6%
t	1162	5.4%
l	1044	4.9%
Other values (27)	5770	26.9%

Uppercase Letter

Value	Count	Frequency (%)
A	11125	12.8%
O	7571	8.7%
N	6931	8.0%
S	6386	7.4%
E	5583	6.4%
I	5554	6.4%
R	5257	6.1%
X	5136	5.9%
D	4606	5.3%
P	3812	4.4%
Other values (22)	24829	28.6%

Other Punctuation

Value	Count	Frequency (%)
/	13685	72.4%
*	2606	13.8%
.	1700	9.0%
:	406	2.1%
,	377	2.0%
?	34	0.2%
\	26	0.1%
'	26	0.1%
;	19	0.1%
#	4	< 0.1%
Other values (4)	6	< 0.1%

Decimal Number

Value	Count	Frequency (%)
2	64037	22.6%
0	53294	18.8%
1	47457	16.8%
3	23376	8.3%
4	20677	7.3%
6	17280	6.1%
5	14773	5.2%
7	14725	5.2%
8	13949	4.9%
9	13633	4.8%

Math Symbol

Value	Count	Frequency (%)
+	86	91.5%
\|	6	6.4%
>	1	1.1%
<	1	1.1%

Other Letter

Value	Count	Frequency (%)
º	340	98.3%
ª	6	1.7%

Space Separator

Value	Count	Frequency (%)
	18610	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	5466	100.0%

Other Symbol

Value	Count	Frequency (%)
°	229	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	219	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	129	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	128	100.0%

Control

Value	Count	Frequency (%)
	3	100.0%

Other Number

Value	Count	Frequency (%)
²	2	100.0%

Modifier Symbol

Value	Count	Frequency (%)
´	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	326971	75.1%
Latin	108609	24.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	11125	10.2%
O	7571	7.0%
N	6931	6.4%
S	6386	5.9%
E	5583	5.1%
I	5554	5.1%
R	5257	4.8%
X	5136	4.7%
D	4606	4.2%
P	3812	3.5%
Other values (61)	46648	43.0%

Common

Value	Count	Frequency (%)
2	64037	19.6%
0	53294	16.3%
1	47457	14.5%
3	23376	7.1%
4	20677	6.3%
	18610	5.7%
6	17280	5.3%
5	14773	4.5%
7	14725	4.5%
8	13949	4.3%
Other values (27)	38793	11.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	434646	99.8%
None	934	0.2%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	64037	14.7%
0	53294	12.3%
1	47457	10.9%
3	23376	5.4%
4	20677	4.8%
	18610	4.3%
6	17280	4.0%
5	14773	3.4%
7	14725	3.4%
8	13949	3.2%
Other values (75)	146468	33.7%

None

Value	Count	Frequency (%)
º	340	36.4%
°	229	24.5%
Á	114	12.2%
á	109	11.7%
é	46	4.9%
Ó	25	2.7%
Ñ	19	2.0%
ó	12	1.3%
É	7	0.7%
ª	6	0.6%
Other values (13)	27	2.9%

problema
Text

Distinct	39897
Distinct (%)	57.8%
Missing	1427
Missing (%)	2.0%
Memory size	8.2 MiB

Length

Max length	250
Median length	228
Mean length	42.525523
Min length	1

Characters and Unicode

Total characters	2934091
Distinct characters	149
Distinct categories	17 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	33858 ?
Unique (%)	49.1%

Sample

1st row	NECESITAMOS CAMBIO A TERMOSTATO THINK RADIO BLANCO.
2nd row	NECESITAMOS CAMBIO A TERMOSTATO LITE RADIO BLANCO, 3 UDS.
3rd row	NECCESITAMOS QUE NOS ENVIEN 1 TERMOSTATO RADIO AZRA6LITERB
4th row	SOLICITUD DEVOLUCIÓN O REPROCESO A LA SAM2
5th row	SOLICITUD DEVOLUCIÓN O REPROCESO A LA SAM2

Value	Count	Frequency (%)
de	16394	3.5%
no	9746	2.1%
la	9683	2.1%
el	7908	1.7%
en	7727	1.7%
se	6262	1.4%
	5877	1.3%
por	5844	1.3%
que	4928	1.1%
y	4887	1.1%
Other values (33774)	383013	82.9%

Most occurring characters

Value	Count	Frequency (%)
	388450	13.2%
E	162137	5.5%
e	135280	4.6%
A	135091	4.6%
O	117742	4.0%
N	109000	3.7%
a	99115	3.4%
I	92971	3.2%
R	91947	3.1%
o	87322	3.0%
Other values (139)	1515036	51.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1293797	44.1%
Lowercase Letter	1001220	34.1%
Space Separator	388457	13.2%
Decimal Number	169126	5.8%
Other Punctuation	42653	1.5%
Control	23298	0.8%
Dash Punctuation	4886	0.2%
Other Symbol	3609	0.1%
Open Punctuation	2200	0.1%
Close Punctuation	2128	0.1%
Other values (7)	2717	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	135280	13.5%
a	99115	9.9%
o	87322	8.7%
n	78178	7.8%
i	72603	7.3%
r	68738	6.9%
t	66081	6.6%
l	57221	5.7%
s	55246	5.5%
c	47863	4.8%
Other values (38)	233573	23.3%

Uppercase Letter

Value	Count	Frequency (%)
E	162137	12.5%
A	135091	10.4%
O	117742	9.1%
N	109000	8.4%
I	92971	7.2%
R	91947	7.1%
T	81223	6.3%
S	67697	5.2%
L	67211	5.2%
C	63555	4.9%
Other values (36)	305223	23.6%

Other Punctuation

Value	Count	Frequency (%)
.	18429	43.2%
,	10663	25.0%
\	3445	8.1%
'	3056	7.2%
:	2533	5.9%
/	2315	5.4%
?	716	1.7%
*	707	1.7%
"	284	0.7%
!	217	0.5%
Other values (8)	288	0.7%

Decimal Number

Value	Count	Frequency (%)
0	33415	19.8%
2	28976	17.1%
1	24915	14.7%
3	15340	9.1%
4	14685	8.7%
6	13760	8.1%
5	11407	6.7%
8	9160	5.4%
7	8951	5.3%
9	8517	5.0%

Math Symbol

Value	Count	Frequency (%)
+	776	81.5%
>	96	10.1%
=	59	6.2%
<	21	2.2%

Modifier Symbol

Value	Count	Frequency (%)
´	5	45.5%
`	4	36.4%
¨	1	9.1%
^	1	9.1%

Control

Value	Count	Frequency (%)
	11500	49.4%
	11497	49.3%
	301	1.3%

Open Punctuation

Value	Count	Frequency (%)
(	2196	99.8%
[	3	0.1%
{	1	< 0.1%

Close Punctuation

Value	Count	Frequency (%)
)	2124	99.8%
]	3	0.1%
}	1	< 0.1%

Space Separator

Value	Count	Frequency (%)
	388450	> 99.9%
	7	< 0.1%

Other Letter

Value	Count	Frequency (%)
º	929	91.2%
ª	90	8.8%

Dash Punctuation

Value	Count	Frequency (%)
-	4886	100.0%

Other Symbol

Value	Count	Frequency (%)
°	3609	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	709	100.0%

Initial Punctuation

Value	Count	Frequency (%)
«	13	100.0%

Final Punctuation

Value	Count	Frequency (%)
»	12	100.0%

Other Number

Value	Count	Frequency (%)
²	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2296035	78.3%
Common	638056	21.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	162137	7.1%
e	135280	5.9%
A	135091	5.9%
O	117742	5.1%
N	109000	4.7%
a	99115	4.3%
I	92971	4.0%
R	91947	4.0%
o	87322	3.8%
T	81223	3.5%
Other values (85)	1184207	51.6%

Common

Value	Count	Frequency (%)
	388450	60.9%
0	33415	5.2%
2	28976	4.5%
1	24915	3.9%
.	18429	2.9%
3	15340	2.4%
4	14685	2.3%
6	13760	2.2%
	11500	1.8%
	11497	1.8%
Other values (44)	77089	12.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2905326	99.0%
None	28765	1.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	388450	13.4%
E	162137	5.6%
e	135280	4.7%
A	135091	4.6%
O	117742	4.1%
N	109000	3.8%
a	99115	3.4%
I	92971	3.2%
R	91947	3.2%
o	87322	3.0%
Other values (85)	1486271	51.2%

None

Value	Count	Frequency (%)
é	9112	31.7%
ó	3760	13.1%
°	3609	12.5%
Ó	2436	8.5%
è	1826	6.3%
í	1399	4.9%
á	969	3.4%
à	967	3.4%
º	929	3.2%
Í	595	2.1%
Other values (44)	3163	11.0%

is_replacement
Text

Distinct	2
Distinct (%)	< 0.1%
Missing	1426
Missing (%)	2.0%
Memory size	3.9 MiB

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	68997
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Value	Count	Frequency (%)
0	68822	99.7%
1	175	0.3%

Most occurring characters

Value	Count	Frequency (%)
0	68822	99.7%
1	175	0.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	68997	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	68822	99.7%
1	175	0.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	68997	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	68822	99.7%
1	175	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	68997	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	68822	99.7%
1	175	0.3%

creation_date_pieza
Date

Distinct	68910
Distinct (%)	99.9%
Missing	1426
Missing (%)	2.0%
Memory size	550.3 KiB

Minimum	2020-01-02 09:03:18
Maximum	2024-09-30 18:09:25
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

modification_date_pieza
Date

Distinct	68905
Distinct (%)	99.9%
Missing	1426
Missing (%)	2.0%
Memory size	550.3 KiB

Minimum	2020-01-02 09:03:18
Maximum	2024-10-07 14:46:55
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

id_estado
Real number (ℝ)

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.733908

Minimum	1
Maximum	76
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	619.1 KiB

Quantile statistics

Minimum	1
5-th percentile	6
Q1	6
median	6
Q3	6
95-th percentile	76
Maximum	76
Range	75
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	20.79176
Coefficient of variation (CV)	1.6327871
Kurtosis	5.3647795
Mean	12.733908
Median Absolute Deviation (MAD)	0
Skewness	2.7128909
Sum	896760
Variance	432.2973
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
6	60356	85.7%
76	6862	9.7%
4	2589	3.7%
5	526	0.7%
1	54	0.1%
2	36	0.1%

Value	Count	Frequency (%)
1	54	0.1%
2	36	0.1%
4	2589	3.7%
5	526	0.7%
6	60356	85.7%
76	6862	9.7%

Value	Count	Frequency (%)
76	6862	9.7%
6	60356	85.7%
5	526	0.7%
4	2589	3.7%
2	36	0.1%
1	54	0.1%

ref
Text

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.6 MiB

Length

Max length	11
Median length	11
Mean length	11
Min length	11

Characters and Unicode

Total characters	774653
Distinct characters	9
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	GARANTIA-ES
2nd row	GARANTIA-ES
3rd row	GARANTIA-ES
4th row	GARANTIA-ES
5th row	GARANTIA-ES

Value	Count	Frequency (%)
garantia-es	70423	100.0%

Most occurring characters

Value	Count	Frequency (%)
A	211269	27.3%
G	70423	9.1%
R	70423	9.1%
N	70423	9.1%
T	70423	9.1%
I	70423	9.1%
-	70423	9.1%
E	70423	9.1%
S	70423	9.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	704230	90.9%
Dash Punctuation	70423	9.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	211269	30.0%
G	70423	10.0%
R	70423	10.0%
N	70423	10.0%
T	70423	10.0%
I	70423	10.0%
E	70423	10.0%
S	70423	10.0%

Dash Punctuation

Value	Count	Frequency (%)
-	70423	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	704230	90.9%
Common	70423	9.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	211269	30.0%
G	70423	10.0%
R	70423	10.0%
N	70423	10.0%
T	70423	10.0%
I	70423	10.0%
E	70423	10.0%
S	70423	10.0%

Common

Value	Count	Frequency (%)
-	70423	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	774653	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	211269	27.3%
G	70423	9.1%
R	70423	9.1%
N	70423	9.1%
T	70423	9.1%
I	70423	9.1%
-	70423	9.1%
E	70423	9.1%
S	70423	9.1%

color
Text

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	422538
Distinct characters	13
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	F7A54A
2nd row	F7A54A
3rd row	18A689
4th row	18A689
5th row	18A689

Value	Count	Frequency (%)
18a689	60356	85.7%
cc0000	6862	9.7%
1a7bb9	2625	3.7%
f7a54a	526	0.7%
ec4758	54	0.1%

Most occurring characters

Value	Count	Frequency (%)
8	120766	28.6%
A	64033	15.2%
1	62981	14.9%
9	62981	14.9%
6	60356	14.3%
0	27448	6.5%
C	13778	3.3%
B	5250	1.2%
7	3205	0.8%
5	580	0.1%
Other values (3)	1160	0.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	338897	80.2%
Uppercase Letter	83641	19.8%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
8	120766	35.6%
1	62981	18.6%
9	62981	18.6%
6	60356	17.8%
0	27448	8.1%
7	3205	0.9%
5	580	0.2%
4	580	0.2%

Uppercase Letter

Value	Count	Frequency (%)
A	64033	76.6%
C	13778	16.5%
B	5250	6.3%
F	526	0.6%
E	54	0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	338897	80.2%
Latin	83641	19.8%

Most frequent character per script

Common

Value	Count	Frequency (%)
8	120766	35.6%
1	62981	18.6%
9	62981	18.6%
6	60356	17.8%
0	27448	8.1%
7	3205	0.9%
5	580	0.2%
4	580	0.2%

Latin

Value	Count	Frequency (%)
A	64033	76.6%
C	13778	16.5%
B	5250	6.3%
F	526	0.6%
E	54	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	422538	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
8	120766	28.6%
A	64033	15.2%
1	62981	14.9%
9	62981	14.9%
6	60356	14.3%
0	27448	6.5%
C	13778	3.3%
B	5250	1.2%
7	3205	0.8%
5	580	0.1%
Other values (3)	1160	0.3%

valor
Text

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.0 MiB

Length

Max length	3
Median length	3
Mean length	2.9544893
Min length	2

Characters and Unicode

Total characters	208064
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	80
2nd row	80
3rd row	100
4th row	100
5th row	100

Value	Count	Frequency (%)
100	67218	95.4%
60	2589	3.7%
80	526	0.7%
12	54	0.1%
26	36	0.1%

Most occurring characters

Value	Count	Frequency (%)
0	137551	66.1%
1	67272	32.3%
6	2625	1.3%
8	526	0.3%
2	90	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	208064	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	137551	66.1%
1	67272	32.3%
6	2625	1.3%
8	526	0.3%
2	90	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	208064	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	137551	66.1%
1	67272	32.3%
6	2625	1.3%
8	526	0.3%
2	90	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	208064	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	137551	66.1%
1	67272	32.3%
6	2625	1.3%
8	526	0.3%
2	90	< 0.1%

titulo_es
Text

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.3 MiB

Length

Max length	11
Median length	7
Mean length	7.1699729
Min length	7

Characters and Unicode

Total characters	504931
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	R.Validada
2nd row	R.Validada
3rd row	Cerrada
4th row	Cerrada
5th row	Cerrada

Value	Count	Frequency (%)
cerrada	60356	85.7%
anulada	6862	9.7%
r.tramitada	2589	3.7%
r.validada	526	0.7%
abierta	54	0.1%
validada	36	0.1%

Most occurring characters

Value	Count	Frequency (%)
a	143943	28.5%
r	123355	24.4%
d	70931	14.0%
e	60410	12.0%
C	60356	12.0%
l	7424	1.5%
A	6916	1.4%
n	6862	1.4%
u	6862	1.4%
i	3205	0.6%
Other values (7)	14667	2.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	428278	84.8%
Uppercase Letter	73538	14.6%
Other Punctuation	3115	0.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	143943	33.6%
r	123355	28.8%
d	70931	16.6%
e	60410	14.1%
l	7424	1.7%
n	6862	1.6%
u	6862	1.6%
i	3205	0.7%
t	2643	0.6%
m	2589	0.6%

Uppercase Letter

Value	Count	Frequency (%)
C	60356	82.1%
A	6916	9.4%
R	3115	4.2%
T	2589	3.5%
V	562	0.8%

Other Punctuation

Value	Count	Frequency (%)
.	3115	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	501816	99.4%
Common	3115	0.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	143943	28.7%
r	123355	24.6%
d	70931	14.1%
e	60410	12.0%
C	60356	12.0%
l	7424	1.5%
A	6916	1.4%
n	6862	1.4%
u	6862	1.4%
i	3205	0.6%
Other values (6)	11552	2.3%

Common

Value	Count	Frequency (%)
.	3115	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	504931	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	143943	28.5%
r	123355	24.4%
d	70931	14.0%
e	60410	12.0%
C	60356	12.0%
l	7424	1.5%
A	6916	1.4%
n	6862	1.4%
u	6862	1.4%
i	3205	0.6%
Other values (7)	14667	2.9%

titulo_en
Text

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.3 MiB

Length

Max length	15
Median length	6
Mean length	6.5428482
Min length	4

Characters and Unicode

Total characters	460767
Distinct characters	24
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Accepted pickup
2nd row	Accepted pickup
3rd row	Closed
4th row	Closed
5th row	Closed

Value	Count	Frequency (%)
closed	60356	85.1%
anuladaen	6862	9.7%
r.tramitada	2589	3.6%
accepted	562	0.8%
pickup	526	0.7%
open	54	0.1%

Most occurring characters

Value	Count	Frequency (%)
d	70369	15.3%
l	67218	14.6%
e	61534	13.4%
C	60356	13.1%
o	60356	13.1%
s	60356	13.1%
a	21491	4.7%
A	7424	1.6%
u	7388	1.6%
n	6916	1.5%
Other values (14)	37359	8.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	370916	80.5%
Uppercase Letter	86736	18.8%
Other Punctuation	2589	0.6%
Space Separator	526	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
d	70369	19.0%
l	67218	18.1%
e	61534	16.6%
o	60356	16.3%
s	60356	16.3%
a	21491	5.8%
u	7388	2.0%
n	6916	1.9%
t	3151	0.8%
i	3115	0.8%
Other values (5)	9022	2.4%

Uppercase Letter

Value	Count	Frequency (%)
C	60356	69.6%
A	7424	8.6%
E	6862	7.9%
N	6862	7.9%
R	2589	3.0%
T	2589	3.0%
O	54	0.1%

Other Punctuation

Value	Count	Frequency (%)
.	2589	100.0%

Space Separator

Value	Count	Frequency (%)
	526	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	457652	99.3%
Common	3115	0.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
d	70369	15.4%
l	67218	14.7%
e	61534	13.4%
C	60356	13.2%
o	60356	13.2%
s	60356	13.2%
a	21491	4.7%
A	7424	1.6%
u	7388	1.6%
n	6916	1.5%
Other values (12)	34244	7.5%

Common

Value	Count	Frequency (%)
.	2589	83.1%
	526	16.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	460767	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
d	70369	15.3%
l	67218	14.6%
e	61534	13.4%
C	60356	13.1%
o	60356	13.1%
s	60356	13.1%
a	21491	4.7%
A	7424	1.6%
u	7388	1.6%
n	6916	1.5%
Other values (14)	37359	8.1%

titulo_fr
Text

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.3 MiB

Length

Max length	15
Median length	6
Mean length	6.4898542
Min length	6

Characters and Unicode

Total characters	457035
Distinct characters	19
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Retour accepté
2nd row	Retour accepté
3rd row	Fermée
4th row	Fermée
5th row	Fermée

Value	Count	Frequency (%)
fermée	60356	79.3%
annulée	6862	9.0%
retour	3115	4.1%
en	2589	3.4%
cours	2589	3.4%
accepté	526	0.7%
ouverte	54	0.1%
acceptée	36	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
e	133984	29.3%
é	67780	14.8%
r	66114	14.5%
F	60356	13.2%
m	60356	13.2%
n	16313	3.6%
u	12620	2.8%
A	6898	1.5%
l	6862	1.5%
o	5704	1.2%
Other values (9)	20048	4.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	380908	83.3%
Uppercase Letter	70423	15.4%
Space Separator	5704	1.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	133984	35.2%
é	67780	17.8%
r	66114	17.4%
m	60356	15.8%
n	16313	4.3%
u	12620	3.3%
l	6862	1.8%
o	5704	1.5%
t	3731	1.0%
c	3713	1.0%
Other values (4)	3731	1.0%

Uppercase Letter

Value	Count	Frequency (%)
F	60356	85.7%
A	6898	9.8%
R	3115	4.4%
O	54	0.1%

Space Separator

Value	Count	Frequency (%)
	5704	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	451331	98.8%
Common	5704	1.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	133984	29.7%
é	67780	15.0%
r	66114	14.6%
F	60356	13.4%
m	60356	13.4%
n	16313	3.6%
u	12620	2.8%
A	6898	1.5%
l	6862	1.5%
o	5704	1.3%
Other values (8)	14344	3.2%

Common

Value	Count	Frequency (%)
	5704	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	389255	85.2%
None	67780	14.8%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	133984	34.4%
r	66114	17.0%
F	60356	15.5%
m	60356	15.5%
n	16313	4.2%
u	12620	3.2%
A	6898	1.8%
l	6862	1.8%
o	5704	1.5%
	5704	1.5%
Other values (8)	14344	3.7%

None

Value	Count	Frequency (%)
é	67780	100.0%

titulo_it
Text

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.3 MiB

Length

Max length	15
Median length	6
Mean length	6.6770089
Min length	6

Characters and Unicode

Total characters	470215
Distinct characters	19
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Verifica reso
2nd row	Verifica reso
3rd row	Chiusa
4th row	Chiusa
5th row	Chiusa

Value	Count	Frequency (%)
chiusa	60356	79.3%
annullata	6862	9.0%
ritiro	2589	3.4%
in	2589	3.4%
corso	2589	3.4%
verifica	526	0.7%
reso	526	0.7%
aperta	54	0.1%
accettata	36	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
a	74732	15.9%
i	69175	14.7%
u	67218	14.3%
s	63471	13.5%
C	60356	12.8%
h	60356	12.8%
n	16313	3.5%
l	13724	2.9%
t	9613	2.0%
o	8293	1.8%
Other values (9)	26964	5.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	394088	83.8%
Uppercase Letter	70423	15.0%
Space Separator	5704	1.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	74732	19.0%
i	69175	17.6%
u	67218	17.1%
s	63471	16.1%
h	60356	15.3%
n	16313	4.1%
l	13724	3.5%
t	9613	2.4%
o	8293	2.1%
r	6284	1.6%
Other values (4)	4909	1.2%

Uppercase Letter

Value	Count	Frequency (%)
C	60356	85.7%
A	6952	9.9%
R	2589	3.7%
V	526	0.7%

Space Separator

Value	Count	Frequency (%)
	5704	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	464511	98.8%
Common	5704	1.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	74732	16.1%
i	69175	14.9%
u	67218	14.5%
s	63471	13.7%
C	60356	13.0%
h	60356	13.0%
n	16313	3.5%
l	13724	3.0%
t	9613	2.1%
o	8293	1.8%
Other values (8)	21260	4.6%

Common

Value	Count	Frequency (%)
	5704	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	470215	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	74732	15.9%
i	69175	14.7%
u	67218	14.3%
s	63471	13.5%
C	60356	12.8%
h	60356	12.8%
n	16313	3.5%
l	13724	2.9%
t	9613	2.0%
o	8293	1.8%
Other values (9)	26964	5.7%

titulo_pt
Unsupported

Missing	70423
Missing (%)	100.0%
Memory size	550.3 KiB

id_tipo
Real number (ℝ)

Distinct	3
Distinct (%)	< 0.1%
Missing	4
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	1.4434031

Minimum	1
Maximum	3
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	619.1 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	2
Maximum	3
Range	2
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.53161546
Coefficient of variation (CV)	0.36830701
Kurtosis	-0.91586016
Mean	1.4434031
Median Absolute Deviation (MAD)	0
Skewness	0.58400148
Sum	101643
Variance	0.282615
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=3)

Value	Count	Frequency (%)
1	40456	57.4%
2	28702	40.8%
3	1261	1.8%
(Missing)	4	< 0.1%

Value	Count	Frequency (%)
1	40456	57.4%
2	28702	40.8%
3	1261	1.8%

Value	Count	Frequency (%)
3	1261	1.8%
2	28702	40.8%
1	40456	57.4%

titulo_es_tipo
Text

Distinct	3
Distinct (%)	< 0.1%
Missing	4
Missing (%)	< 0.1%
Memory size	4.4 MiB

Length

Max length	10
Median length	8
Mean length	8.8509919
Min length	8

Characters and Unicode

Total characters	623278
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	devolucion
2nd row	devolucion
3rd row	devolucion
4th row	devolucion
5th row	devolucion

Value	Count	Frequency (%)
garantia	40456	57.5%
devolucion	28702	40.8%
reparacion	1261	1.8%

Most occurring characters

Value	Count	Frequency (%)
a	123890	19.9%
n	70419	11.3%
i	70419	11.3%
o	58665	9.4%
r	42978	6.9%
g	40456	6.5%
t	40456	6.5%
e	29963	4.8%
c	29963	4.8%
d	28702	4.6%
Other values (4)	87367	14.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	623278	100.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	123890	19.9%
n	70419	11.3%
i	70419	11.3%
o	58665	9.4%
r	42978	6.9%
g	40456	6.5%
t	40456	6.5%
e	29963	4.8%
c	29963	4.8%
d	28702	4.6%
Other values (4)	87367	14.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	623278	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	123890	19.9%
n	70419	11.3%
i	70419	11.3%
o	58665	9.4%
r	42978	6.9%
g	40456	6.5%
t	40456	6.5%
e	29963	4.8%
c	29963	4.8%
d	28702	4.6%
Other values (4)	87367	14.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	623278	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	123890	19.9%
n	70419	11.3%
i	70419	11.3%
o	58665	9.4%
r	42978	6.9%
g	40456	6.5%
t	40456	6.5%
e	29963	4.8%
c	29963	4.8%
d	28702	4.6%
Other values (4)	87367	14.0%

titulo_en_tipo
Text

Distinct	3
Distinct (%)	< 0.1%
Missing	4
Missing (%)	< 0.1%
Memory size	4.3 MiB

Length

Max length	9
Median length	9
Mean length	7.7235121
Min length	6

Characters and Unicode

Total characters	543882
Distinct characters	9
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	return
2nd row	return
3rd row	return
4th row	return
5th row	return

Value	Count	Frequency (%)
guarantee	40456	57.5%
return	28702	40.8%
repair	1261	1.8%

Most occurring characters

Value	Count	Frequency (%)
e	110875	20.4%
r	100382	18.5%
a	82173	15.1%
u	69158	12.7%
n	69158	12.7%
t	69158	12.7%
g	40456	7.4%
p	1261	0.2%
i	1261	0.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	543882	100.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	110875	20.4%
r	100382	18.5%
a	82173	15.1%
u	69158	12.7%
n	69158	12.7%
t	69158	12.7%
g	40456	7.4%
p	1261	0.2%
i	1261	0.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	543882	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	110875	20.4%
r	100382	18.5%
a	82173	15.1%
u	69158	12.7%
n	69158	12.7%
t	69158	12.7%
g	40456	7.4%
p	1261	0.2%
i	1261	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	543882	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	110875	20.4%
r	100382	18.5%
a	82173	15.1%
u	69158	12.7%
n	69158	12.7%
t	69158	12.7%
g	40456	7.4%
p	1261	0.2%
i	1261	0.2%

titulo_fr_tipo
Text

Distinct	3
Distinct (%)	< 0.1%
Missing	4
Missing (%)	< 0.1%
Memory size	4.3 MiB

Length

Max length	10
Median length	8
Mean length	7.2206365
Min length	6

Characters and Unicode

Total characters	508470
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	retour
2nd row	retour
3rd row	retour
4th row	retour
5th row	retour

Value	Count	Frequency (%)
garantie	40456	57.5%
retour	28702	40.8%
reparation	1261	1.8%

Most occurring characters

Value	Count	Frequency (%)
r	100382	19.7%
a	83434	16.4%
t	70419	13.8%
e	70419	13.8%
n	41717	8.2%
i	41717	8.2%
g	40456	8.0%
o	29963	5.9%
u	28702	5.6%
p	1261	0.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	508470	100.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	100382	19.7%
a	83434	16.4%
t	70419	13.8%
e	70419	13.8%
n	41717	8.2%
i	41717	8.2%
g	40456	8.0%
o	29963	5.9%
u	28702	5.6%
p	1261	0.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	508470	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	100382	19.7%
a	83434	16.4%
t	70419	13.8%
e	70419	13.8%
n	41717	8.2%
i	41717	8.2%
g	40456	8.0%
o	29963	5.9%
u	28702	5.6%
p	1261	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	508470	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	100382	19.7%
a	83434	16.4%
t	70419	13.8%
e	70419	13.8%
n	41717	8.2%
i	41717	8.2%
g	40456	8.0%
o	29963	5.9%
u	28702	5.6%
p	1261	0.2%

titulo_it_tipo
Text

Distinct	3
Distinct (%)	< 0.1%
Missing	4
Missing (%)	< 0.1%
Memory size	4.3 MiB

Length

Max length	11
Median length	8
Mean length	7.6461324
Min length	7

Characters and Unicode

Total characters	538433
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	ritorno
2nd row	ritorno
3rd row	ritorno
4th row	ritorno
5th row	ritorno

Value	Count	Frequency (%)
garanzia	40456	57.5%
ritorno	28702	40.8%
riparazione	1261	1.8%

Most occurring characters

Value	Count	Frequency (%)
a	123890	23.0%
r	100382	18.6%
i	71680	13.3%
n	70419	13.1%
o	58665	10.9%
z	41717	7.7%
g	40456	7.5%
t	28702	5.3%
p	1261	0.2%
e	1261	0.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	538433	100.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	123890	23.0%
r	100382	18.6%
i	71680	13.3%
n	70419	13.1%
o	58665	10.9%
z	41717	7.7%
g	40456	7.5%
t	28702	5.3%
p	1261	0.2%
e	1261	0.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	538433	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	123890	23.0%
r	100382	18.6%
i	71680	13.3%
n	70419	13.1%
o	58665	10.9%
z	41717	7.7%
g	40456	7.5%
t	28702	5.3%
p	1261	0.2%
e	1261	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	538433	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	123890	23.0%
r	100382	18.6%
i	71680	13.3%
n	70419	13.1%
o	58665	10.9%
z	41717	7.7%
g	40456	7.5%
t	28702	5.3%
p	1261	0.2%
e	1261	0.2%

titulo_pt_tipo
Unsupported

Missing	70423
Missing (%)	100.0%
Memory size	550.3 KiB

desc_problema_translated
Text

Distinct	12956
Distinct (%)	68.9%
Missing	543
Missing (%)	2.8%
Memory size	2.6 MiB

Length

Max length	582
Median length	460
Mean length	76.8201
Min length	1

Characters and Unicode

Total characters	1445447
Distinct characters	131
Distinct categories	18 ?
Distinct scripts	2 ?
Distinct blocks	4 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	10700 ?
Unique (%)	56.9%

Sample

1st row	Después del diagnóstico de HOTLINE
2nd row	Después del diagnóstico de HOTLINE
3rd row	Después del diagnóstico de HOTLINE
4th row	CAMBIO CPP EN GARANTIA POR PROBLEMAS COMUNICACION
5th row	TARJETA POTENTE PARA 8 ZONAS

Value	Count	Frequency (%)
de	12301	5.3%
no	7541	3.3%
el	7127	3.1%
la	6878	3.0%
en	5104	2.2%
y	4292	1.9%
se	4263	1.9%
que	4023	1.7%
con	3990	1.7%
funciona	2814	1.2%
Other values (14919)	171678	74.6%

Most occurring characters

Value	Count	Frequency (%)
	205989	14.3%
e	78367	5.4%
a	70344	4.9%
A	67014	4.6%
E	66103	4.6%
o	56965	3.9%
n	47987	3.3%
O	46573	3.2%
N	44349	3.1%
r	39104	2.7%
Other values (121)	722652	50.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	595509	41.2%
Uppercase Letter	549004	38.0%
Space Separator	205991	14.3%
Decimal Number	49618	3.4%
Other Punctuation	21147	1.5%
Control	17658	1.2%
Dash Punctuation	1676	0.1%
Open Punctuation	1266	0.1%
Close Punctuation	1232	0.1%
Other Symbol	1099	0.1%
Other values (8)	1247	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	78367	13.2%
a	70344	11.8%
o	56965	9.6%
n	47987	8.1%
r	39104	6.6%
i	37277	6.3%
t	36238	6.1%
l	34162	5.7%
s	33997	5.7%
c	30178	5.1%
Other values (28)	130890	22.0%

Uppercase Letter

Value	Count	Frequency (%)
A	67014	12.2%
E	66103	12.0%
O	46573	8.5%
N	44349	8.1%
I	34347	6.3%
T	33670	6.1%
R	32673	6.0%
L	30667	5.6%
C	30250	5.5%
S	30089	5.5%
Other values (28)	133269	24.3%

Other Punctuation

Value	Count	Frequency (%)
.	10420	49.3%
,	6212	29.4%
:	1975	9.3%
/	1455	6.9%
"	255	1.2%
?	225	1.1%
%	92	0.4%
;	89	0.4%
*	85	0.4%
\	84	0.4%
Other values (8)	255	1.2%

Decimal Number

Value	Count	Frequency (%)
0	9874	19.9%
1	7176	14.5%
2	6763	13.6%
6	6188	12.5%
3	4680	9.4%
5	3535	7.1%
4	3403	6.9%
8	2966	6.0%
7	2560	5.2%
9	2473	5.0%

Math Symbol

Value	Count	Frequency (%)
+	469	74.8%
>	104	16.6%
=	36	5.7%
<	17	2.7%
\|	1	0.2%

Control

Value	Count	Frequency (%)
	8855	50.1%
	8690	49.2%
	113	0.6%

Space Separator

Value	Count	Frequency (%)
	205989	> 99.9%
	2	< 0.1%

Dash Punctuation

Value	Count	Frequency (%)
-	1673	99.8%
–	3	0.2%

Open Punctuation

Value	Count	Frequency (%)
(	1265	99.9%
[	1	0.1%

Close Punctuation

Value	Count	Frequency (%)
)	1231	99.9%
]	1	0.1%

Other Symbol

Value	Count	Frequency (%)
°	1095	99.6%
™	4	0.4%

Other Letter

Value	Count	Frequency (%)
º	461	95.6%
ª	21	4.4%

Modifier Symbol

Value	Count	Frequency (%)
´	2	66.7%
`	1	33.3%

Connector Punctuation

Value	Count	Frequency (%)
_	78	100.0%

Initial Punctuation

Value	Count	Frequency (%)
“	25	100.0%

Final Punctuation

Value	Count	Frequency (%)
”	25	100.0%

Format

Value	Count	Frequency (%)
	6	100.0%

Currency Symbol

Value	Count	Frequency (%)
£	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1144995	79.2%
Common	300452	20.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	78367	6.8%
a	70344	6.1%
A	67014	5.9%
E	66103	5.8%
o	56965	5.0%
n	47987	4.2%
O	46573	4.1%
N	44349	3.9%
r	39104	3.4%
i	37277	3.3%
Other values (68)	590912	51.6%

Common

Value	Count	Frequency (%)
	205989	68.6%
.	10420	3.5%
0	9874	3.3%
	8855	2.9%
	8690	2.9%
1	7176	2.4%
2	6763	2.3%
,	6212	2.1%
6	6188	2.1%
3	4680	1.6%
Other values (43)	25605	8.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1429298	98.9%
None	16086	1.1%
Punctuation	59	< 0.1%
Letterlike Symbols	4	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	205989	14.4%
e	78367	5.5%
a	70344	4.9%
A	67014	4.7%
E	66103	4.6%
o	56965	4.0%
n	47987	3.4%
O	46573	3.3%
N	44349	3.1%
r	39104	2.7%
Other values (83)	706503	49.4%

None

Value	Count	Frequency (%)
ó	3799	23.6%
í	2550	15.9%
Ó	1964	12.2%
Í	1323	8.2%
á	1194	7.4%
é	1184	7.4%
°	1095	6.8%
ú	896	5.6%
º	461	2.9%
ñ	367	2.3%
Other values (23)	1253	7.8%

Punctuation

Value	Count	Frequency (%)
“	25	42.4%
”	25	42.4%
	6	10.2%
–	3	5.1%

Letterlike Symbols

Value	Count	Frequency (%)
™	4	100.0%

descripcion_translated
Text

Distinct	5634
Distinct (%)	36.1%
Missing	3752
Missing (%)	19.4%
Memory size	1.4 MiB

Length

Max length	76
Median length	51
Mean length	27.055488
Min length	1

Characters and Unicode

Total characters	422255
Distinct characters	104
Distinct categories	12 ?
Distinct scripts	2 ?
Distinct blocks	3 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3989 ?
Unique (%)	25.6%

Sample

1st row	Pasarela de comunicaciones HITACHI RPI
2nd row	Puerta de enlace de comunicación
3rd row	CENTRAL DE PRODUCCION
4th row	0000
5th row	MANDO

Value	Count	Frequency (%)
termostato	4048	6.5%
de	3402	5.5%
airzone	2990	4.8%
central	1776	2.9%
radio	1563	2.5%
blanco	1425	2.3%
cable	1389	2.2%
web	1280	2.1%
blueface	1260	2.0%
servidor	1243	2.0%
Other values (2564)	41511	67.1%

Most occurring characters

Value	Count	Frequency (%)
	46338	11.0%
A	31677	7.5%
E	29936	7.1%
O	27825	6.6%
T	22251	5.3%
R	22182	5.3%
I	18379	4.4%
N	17075	4.0%
L	15748	3.7%
C	14488	3.4%
Other values (94)	176356	41.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	274083	64.9%
Lowercase Letter	84826	20.1%
Space Separator	46338	11.0%
Decimal Number	12341	2.9%
Other Punctuation	2615	0.6%
Dash Punctuation	1233	0.3%
Open Punctuation	378	0.1%
Close Punctuation	269	0.1%
Math Symbol	129	< 0.1%
Other Symbol	26	< 0.1%
Other values (2)	17	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	31677	11.6%
E	29936	10.9%
O	27825	10.2%
T	22251	8.1%
R	22182	8.1%
I	18379	6.7%
N	17075	6.2%
L	15748	5.7%
C	14488	5.3%
S	10014	3.7%
Other values (24)	64508	23.5%

Lowercase Letter

Value	Count	Frequency (%)
a	10202	12.0%
e	9738	11.5%
o	9717	11.5%
r	7493	8.8%
t	6405	7.6%
n	5622	6.6%
i	5447	6.4%
l	4593	5.4%
c	4443	5.2%
d	3764	4.4%
Other values (22)	17402	20.5%

Other Punctuation

Value	Count	Frequency (%)
.	2020	77.2%
/	303	11.6%
*	132	5.0%
,	88	3.4%
:	25	1.0%
\	13	0.5%
?	10	0.4%
"	8	0.3%
¿	5	0.2%
'	3	0.1%
Other values (5)	8	0.3%

Decimal Number

Value	Count	Frequency (%)
0	3320	26.9%
6	2294	18.6%
3	1686	13.7%
2	1335	10.8%
8	1282	10.4%
5	993	8.0%
1	905	7.3%
4	417	3.4%
7	79	0.6%
9	30	0.2%

Open Punctuation

Value	Count	Frequency (%)
(	375	99.2%
[	3	0.8%

Close Punctuation

Value	Count	Frequency (%)
)	266	98.9%
]	3	1.1%

Math Symbol

Value	Count	Frequency (%)
+	124	96.1%
>	5	3.9%

Other Symbol

Value	Count	Frequency (%)
™	20	76.9%
°	6	23.1%

Other Letter

Value	Count	Frequency (%)
º	15	93.8%
ª	1	6.2%

Space Separator

Value	Count	Frequency (%)
	46338	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1233	100.0%

Control

Value	Count	Frequency (%)
	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	358925	85.0%
Common	63330	15.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	31677	8.8%
E	29936	8.3%
O	27825	7.8%
T	22251	6.2%
R	22182	6.2%
I	18379	5.1%
N	17075	4.8%
L	15748	4.4%
C	14488	4.0%
a	10202	2.8%
Other values (58)	149162	41.6%

Common

Value	Count	Frequency (%)
	46338	73.2%
0	3320	5.2%
6	2294	3.6%
.	2020	3.2%
3	1686	2.7%
2	1335	2.1%
8	1282	2.0%
-	1233	1.9%
5	993	1.6%
1	905	1.4%
Other values (26)	1924	3.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	420365	99.6%
None	1870	0.4%
Letterlike Symbols	20	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	46338	11.0%
A	31677	7.5%
E	29936	7.1%
O	27825	6.6%
T	22251	5.3%
R	22182	5.3%
I	18379	4.4%
N	17075	4.1%
L	15748	3.7%
C	14488	3.4%
Other values (72)	174466	41.5%

None

Value	Count	Frequency (%)
Ó	867	46.4%
ó	407	21.8%
É	208	11.1%
á	134	7.2%
Á	71	3.8%
é	69	3.7%
Í	26	1.4%
Ú	23	1.2%
º	15	0.8%
Ø	13	0.7%
Other values (11)	37	2.0%

Letterlike Symbols

Value	Count	Frequency (%)
™	20	100.0%

problema_translated
Text

Distinct	13486
Distinct (%)	69.7%
Missing	1
Missing (%)	< 0.1%
Memory size	2.1 MiB

Length

Max length	314
Median length	257
Mean length	46.959655
Min length	1

Characters and Unicode

Total characters	909045
Distinct characters	124
Distinct categories	17 ?
Distinct scripts	2 ?
Distinct blocks	3 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	11961 ?
Unique (%)	61.8%

Sample

1st row	No más comunicación, asociación WIFI imposible.
2nd row	problema de comunicacion
3rd row	problema de comunicacion
4th row	fallo en comunicacion central de produccion
5th row	RAS

Value	Count	Frequency (%)
de	7187	4.9%
no	6144	4.2%
el	4753	3.3%
la	4201	2.9%
en	3239	2.2%
funciona	2749	1.9%
se	2676	1.8%
con	2458	1.7%
termostato	2263	1.6%
y	2083	1.4%
Other values (12287)	107942	74.1%

Most occurring characters

Value	Count	Frequency (%)
	124248	13.7%
A	46569	5.1%
E	46206	5.1%
e	43957	4.8%
a	40074	4.4%
O	35680	3.9%
N	34147	3.8%
o	32876	3.6%
n	26951	3.0%
I	25499	2.8%
Other values (114)	452838	49.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	387929	42.7%
Lowercase Letter	336655	37.0%
Space Separator	124250	13.7%
Decimal Number	36352	4.0%
Other Punctuation	12065	1.3%
Control	7771	0.9%
Other Symbol	1050	0.1%
Dash Punctuation	920	0.1%
Open Punctuation	674	0.1%
Close Punctuation	656	0.1%
Other values (7)	723	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	43957	13.1%
a	40074	11.9%
o	32876	9.8%
n	26951	8.0%
r	22325	6.6%
t	21493	6.4%
i	21277	6.3%
l	19515	5.8%
c	17810	5.3%
s	17386	5.2%
Other values (27)	72991	21.7%

Uppercase Letter

Value	Count	Frequency (%)
A	46569	12.0%
E	46206	11.9%
O	35680	9.2%
N	34147	8.8%
I	25499	6.6%
T	24328	6.3%
R	23754	6.1%
C	21393	5.5%
L	20548	5.3%
S	19517	5.0%
Other values (25)	90288	23.3%

Other Punctuation

Value	Count	Frequency (%)
.	6219	51.5%
,	3475	28.8%
:	944	7.8%
/	600	5.0%
\	156	1.3%
*	156	1.3%
"	141	1.2%
?	140	1.2%
%	63	0.5%
¿	50	0.4%
Other values (7)	121	1.0%

Decimal Number

Value	Count	Frequency (%)
0	6186	17.0%
1	5340	14.7%
2	4934	13.6%
6	4028	11.1%
3	3554	9.8%
4	2785	7.7%
5	2708	7.4%
8	2404	6.6%
7	2235	6.1%
9	2178	6.0%

Math Symbol

Value	Count	Frequency (%)
+	193	75.4%
>	40	15.6%
=	17	6.6%
<	6	2.3%

Control

Value	Count	Frequency (%)
	3937	50.7%
	3789	48.8%
	45	0.6%

Modifier Symbol

Value	Count	Frequency (%)
´	1	33.3%
¨	1	33.3%
`	1	33.3%

Space Separator

Value	Count	Frequency (%)
	124248	> 99.9%
	2	< 0.1%

Dash Punctuation

Value	Count	Frequency (%)
-	918	99.8%
–	2	0.2%

Open Punctuation

Value	Count	Frequency (%)
(	672	99.7%
[	2	0.3%

Close Punctuation

Value	Count	Frequency (%)
)	654	99.7%
]	2	0.3%

Other Letter

Value	Count	Frequency (%)
º	274	95.8%
ª	12	4.2%

Other Symbol

Value	Count	Frequency (%)
°	1050	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	158	100.0%

Format

Value	Count	Frequency (%)
	16	100.0%

Initial Punctuation

Value	Count	Frequency (%)
“	2	100.0%

Final Punctuation

Value	Count	Frequency (%)
”	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	724870	79.7%
Common	184175	20.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	46569	6.4%
E	46206	6.4%
e	43957	6.1%
a	40074	5.5%
O	35680	4.9%
N	34147	4.7%
o	32876	4.5%
n	26951	3.7%
I	25499	3.5%
T	24328	3.4%
Other values (64)	368583	50.8%

Common

Value	Count	Frequency (%)
	124248	67.5%
.	6219	3.4%
0	6186	3.4%
1	5340	2.9%
2	4934	2.7%
6	4028	2.2%
	3937	2.1%
	3789	2.1%
3	3554	1.9%
,	3475	1.9%
Other values (40)	18465	10.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	898373	98.8%
None	10650	1.2%
Punctuation	22	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	124248	13.8%
A	46569	5.2%
E	46206	5.1%
e	43957	4.9%
a	40074	4.5%
O	35680	4.0%
N	34147	3.8%
o	32876	3.7%
n	26951	3.0%
I	25499	2.8%
Other values (81)	442166	49.2%

None

Value	Count	Frequency (%)
ó	2224	20.9%
í	1464	13.7%
Ó	1375	12.9%
Í	1139	10.7%
°	1050	9.9%
á	750	7.0%
é	604	5.7%
ú	523	4.9%
º	274	2.6%
Ú	256	2.4%
Other values (19)	991	9.3%

Punctuation

Value	Count	Frequency (%)
	16	72.7%
–	2	9.1%
“	2	9.1%
”	2	9.1%

CODART_A3
Text

Distinct	1141
Distinct (%)	5.9%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

Length

Max length	15
Median length	14
Mean length	12.179348
Min length	3

Characters and Unicode

Total characters	235780
Distinct characters	39
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	591 ?
Unique (%)	3.1%

Sample

1st row	AZXWSCLOUDWIFI
2nd row	AZX6QADAPTHIT
3rd row	AZX6QADAPTHIT
4th row	AZX6CCP
5th row	AZCE6EXP8Z

Value	Count	Frequency (%)
azce6thinkrb	2086	10.8%
azce6bluefacecb	1690	8.7%
azce6bluezerocb	815	4.2%
azx6wsc5ger	747	3.9%
azce6flexa3	603	3.1%
azpv8cb1iaq	520	2.7%
azce6ibpro6e	457	2.4%
azdi6bluefacecb	411	2.1%
azce6thinkcb	384	2.0%
azx6gtcda1	383	2.0%
Other values (1131)	11263	58.2%

Most occurring characters

Value	Count	Frequency (%)
A	27544	11.7%
C	23649	10.0%
E	20236	8.6%
Z	20117	8.5%
6	17025	7.2%
B	14706	6.2%
I	10314	4.4%
T	8956	3.8%
R	8624	3.7%
L	6658	2.8%
Other values (29)	77951	33.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	203398	86.3%
Decimal Number	32146	13.6%
Dash Punctuation	133	0.1%
Connector Punctuation	55	< 0.1%
Space Separator	48	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	27544	13.5%
C	23649	11.6%
E	20236	9.9%
Z	20117	9.9%
B	14706	7.2%
I	10314	5.1%
T	8956	4.4%
R	8624	4.2%
L	6658	3.3%
N	6538	3.2%
Other values (16)	56056	27.6%

Decimal Number

Value	Count	Frequency (%)
6	17025	53.0%
0	5117	15.9%
1	3613	11.2%
5	1649	5.1%
3	1584	4.9%
8	1532	4.8%
2	1090	3.4%
4	333	1.0%
7	190	0.6%
9	13	< 0.1%

Dash Punctuation

Value	Count	Frequency (%)
-	133	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	55	100.0%

Space Separator

Value	Count	Frequency (%)
	48	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	203398	86.3%
Common	32382	13.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	27544	13.5%
C	23649	11.6%
E	20236	9.9%
Z	20117	9.9%
B	14706	7.2%
I	10314	5.1%
T	8956	4.4%
R	8624	4.2%
L	6658	3.3%
N	6538	3.2%
Other values (16)	56056	27.6%

Common

Value	Count	Frequency (%)
6	17025	52.6%
0	5117	15.8%
1	3613	11.2%
5	1649	5.1%
3	1584	4.9%
8	1532	4.7%
2	1090	3.4%
4	333	1.0%
7	190	0.6%
-	133	0.4%
Other values (3)	116	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	235780	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	27544	11.7%
C	23649	10.0%
E	20236	8.6%
Z	20117	8.5%
6	17025	7.2%
B	14706	6.2%
I	10314	4.4%
T	8956	3.8%
R	8624	3.7%
L	6658	2.8%
Other values (29)	77951	33.1%

Fuzzy_Score
Real number (ℝ)

Distinct	14
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	99.437574

Minimum	85
Maximum	100
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	151.4 KiB

Quantile statistics

Minimum	85
5-th percentile	95
Q1	100
median	100
Q3	100
95-th percentile	100
Maximum	100
Range	15
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	2.0492478
Coefficient of variation (CV)	0.020608385
Kurtosis	16.190582
Mean	99.437574
Median Absolute Deviation (MAD)	0
Skewness	-3.9921457
Sum	1925012
Variance	4.1994167
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
100	17731	91.6%
96	349	1.8%
92	231	1.2%
97	229	1.2%
91	191	1.0%
95	184	1.0%
93	173	0.9%
90	133	0.7%
86	43	0.2%
87	38	0.2%
Other values (4)	57	0.3%

Value	Count	Frequency (%)
85	10	0.1%
86	43	0.2%
87	38	0.2%
88	19	0.1%
89	27	0.1%
90	133	0.7%
91	191	1.0%
92	231	1.2%
93	173	0.9%
94	1	< 0.1%

Value	Count	Frequency (%)
100	17731	91.6%
97	229	1.2%
96	349	1.8%
95	184	1.0%
94	1	< 0.1%
93	173	0.9%
92	231	1.2%
91	191	1.0%
90	133	0.7%
89	27	0.1%

CODART
Text

Distinct	1141
Distinct (%)	5.9%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

Length

Max length	15
Median length	14
Mean length	12.179348
Min length	3

Characters and Unicode

Total characters	235780
Distinct characters	39
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	591 ?
Unique (%)	3.1%

Sample

1st row	AZXWSCLOUDWIFI
2nd row	AZX6QADAPTHIT
3rd row	AZX6QADAPTHIT
4th row	AZX6CCP
5th row	AZCE6EXP8Z

Value	Count	Frequency (%)
azce6thinkrb	2086	10.8%
azce6bluefacecb	1690	8.7%
azce6bluezerocb	815	4.2%
azx6wsc5ger	747	3.9%
azce6flexa3	603	3.1%
azpv8cb1iaq	520	2.7%
azce6ibpro6e	457	2.4%
azdi6bluefacecb	411	2.1%
azce6thinkcb	384	2.0%
azx6gtcda1	383	2.0%
Other values (1131)	11263	58.2%

Most occurring characters

Value	Count	Frequency (%)
A	27544	11.7%
C	23649	10.0%
E	20236	8.6%
Z	20117	8.5%
6	17025	7.2%
B	14706	6.2%
I	10314	4.4%
T	8956	3.8%
R	8624	3.7%
L	6658	2.8%
Other values (29)	77951	33.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	203398	86.3%
Decimal Number	32146	13.6%
Dash Punctuation	133	0.1%
Connector Punctuation	55	< 0.1%
Space Separator	48	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	27544	13.5%
C	23649	11.6%
E	20236	9.9%
Z	20117	9.9%
B	14706	7.2%
I	10314	5.1%
T	8956	4.4%
R	8624	4.2%
L	6658	3.3%
N	6538	3.2%
Other values (16)	56056	27.6%

Decimal Number

Value	Count	Frequency (%)
6	17025	53.0%
0	5117	15.9%
1	3613	11.2%
5	1649	5.1%
3	1584	4.9%
8	1532	4.8%
2	1090	3.4%
4	333	1.0%
7	190	0.6%
9	13	< 0.1%

Dash Punctuation

Value	Count	Frequency (%)
-	133	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	55	100.0%

Space Separator

Value	Count	Frequency (%)
	48	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	203398	86.3%
Common	32382	13.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	27544	13.5%
C	23649	11.6%
E	20236	9.9%
Z	20117	9.9%
B	14706	7.2%
I	10314	5.1%
T	8956	4.4%
R	8624	4.2%
L	6658	3.3%
N	6538	3.2%
Other values (16)	56056	27.6%

Common

Value	Count	Frequency (%)
6	17025	52.6%
0	5117	15.8%
1	3613	11.2%
5	1649	5.1%
3	1584	4.9%
8	1532	4.7%
2	1090	3.4%
4	333	1.0%
7	190	0.6%
-	133	0.4%
Other values (3)	116	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	235780	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	27544	11.7%
C	23649	10.0%
E	20236	8.6%
Z	20117	8.5%
6	17025	7.2%
B	14706	6.2%
I	10314	4.4%
T	8956	3.8%
R	8624	3.7%
L	6658	2.8%
Other values (29)	77951	33.1%

DESCART
Text

Distinct	1134
Distinct (%)	5.9%
Missing	0
Missing (%)	0.0%
Memory size	2.1 MiB

Length

Max length	98
Median length	88
Mean length	49.520068
Min length	5

Characters and Unicode

Total characters	958659
Distinct characters	81
Distinct categories	12 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	587 ?
Unique (%)	3.0%

Sample

1st row	Webserver Airzone Cloud Wi-Fi (2013)
2nd row	Pasarela comunicaciones Airzone-Hitachi RPI
3rd row	Pasarela comunicaciones Airzone-Hitachi RPI
4th row	Central de control de producción Airzone
5th row	Módulo de expansión Airzone 2 zonas (7 y 8)

Value	Count	Frequency (%)
airzone	15405	10.9%
blanco	7140	5.1%
termostato	7085	5.0%
de	6635	4.7%
ce6	6030	4.3%
8z	5752	4.1%
cable	5347	3.8%
central	3778	2.7%
blueface	3650	2.6%
think	2945	2.1%
Other values (709)	77311	54.8%

Most occurring characters

Value	Count	Frequency (%)
	121720	12.7%
o	85371	8.9%
e	76600	8.0%
a	60078	6.3%
r	58041	6.1%
n	50662	5.3%
i	45513	4.7%
l	40169	4.2%
c	35230	3.7%
t	32947	3.4%
Other values (71)	352328	36.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	640859	66.8%
Uppercase Letter	124653	13.0%
Space Separator	121720	12.7%
Decimal Number	43003	4.5%
Open Punctuation	8453	0.9%
Close Punctuation	8453	0.9%
Other Punctuation	5865	0.6%
Dash Punctuation	5038	0.5%
Math Symbol	530	0.1%
Other Letter	64	< 0.1%
Other values (2)	21	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	85371	13.3%
e	76600	12.0%
a	60078	9.4%
r	58041	9.1%
n	50662	7.9%
i	45513	7.1%
l	40169	6.3%
c	35230	5.5%
t	32947	5.1%
m	24768	3.9%
Other values (21)	131480	20.5%

Uppercase Letter

Value	Count	Frequency (%)
A	23291	18.7%
C	13649	10.9%
E	13042	10.5%
T	12556	10.1%
Z	12418	10.0%
R	5132	4.1%
I	4865	3.9%
B	4795	3.8%
M	4618	3.7%
P	4231	3.4%
Other values (16)	26056	20.9%

Decimal Number

Value	Count	Frequency (%)
6	10029	23.3%
0	8710	20.3%
8	7538	17.5%
3	5156	12.0%
2	5082	11.8%
5	2537	5.9%
4	1873	4.4%
1	1797	4.2%
7	254	0.6%
9	27	0.1%

Other Punctuation

Value	Count	Frequency (%)
.	4382	74.7%
/	1181	20.1%
*	182	3.1%
,	100	1.7%
"	19	0.3%
%	1	< 0.1%

Space Separator

Value	Count	Frequency (%)
	121720	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	8453	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	8453	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	5038	100.0%

Math Symbol

Value	Count	Frequency (%)
+	530	100.0%

Other Letter

Value	Count	Frequency (%)
º	64	100.0%

Other Symbol

Value	Count	Frequency (%)
°	16	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	5	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	765576	79.9%
Common	193083	20.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	85371	11.2%
e	76600	10.0%
a	60078	7.8%
r	58041	7.6%
n	50662	6.6%
i	45513	5.9%
l	40169	5.2%
c	35230	4.6%
t	32947	4.3%
m	24768	3.2%
Other values (48)	256197	33.5%

Common

Value	Count	Frequency (%)
	121720	63.0%
6	10029	5.2%
0	8710	4.5%
(	8453	4.4%
)	8453	4.4%
8	7538	3.9%
3	5156	2.7%
2	5082	2.6%
-	5038	2.6%
.	4382	2.3%
Other values (13)	8522	4.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	956694	99.8%
None	1965	0.2%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	121720	12.7%
o	85371	8.9%
e	76600	8.0%
a	60078	6.3%
r	58041	6.1%
n	50662	5.3%
i	45513	4.8%
l	40169	4.2%
c	35230	3.7%
t	32947	3.4%
Other values (64)	350363	36.6%

None

Value	Count	Frequency (%)
ó	1296	66.0%
é	412	21.0%
á	120	6.1%
º	64	3.3%
í	51	2.6%
°	16	0.8%
ú	6	0.3%

CAR1
Text

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	19359
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Value	Count	Frequency (%)
1	18733	96.8%
6	251	1.3%
2	233	1.2%
5	96	0.5%
3	43	0.2%
4	3	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
1	18733	96.8%
6	251	1.3%
2	233	1.2%
5	96	0.5%
3	43	0.2%
4	3	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	19359	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	18733	96.8%
6	251	1.3%
2	233	1.2%
5	96	0.5%
3	43	0.2%
4	3	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	19359	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	18733	96.8%
6	251	1.3%
2	233	1.2%
5	96	0.5%
3	43	0.2%
4	3	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	19359	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	18733	96.8%
6	251	1.3%
2	233	1.2%
5	96	0.5%
3	43	0.2%
4	3	< 0.1%

CAR2
Text

Distinct	26
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Length

Max length	3
Median length	3
Mean length	2.9637895
Min length	1

Characters and Unicode

Total characters	57376
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	260
2nd row	260
3rd row	260
4th row	260
5th row	250

Value	Count	Frequency (%)
250	7956	41.1%
260	4055	20.9%
251	2104	10.9%
264	1183	6.1%
269	1115	5.8%
253	777	4.0%
17	558	2.9%
252	356	1.8%
270	344	1.8%
255	292	1.5%
Other values (16)	619	3.2%

Most occurring characters

Value	Count	Frequency (%)
2	19304	33.6%
0	12378	21.6%
5	11875	20.7%
6	6659	11.6%
1	2748	4.8%
4	1430	2.5%
9	1131	2.0%
7	932	1.6%
3	916	1.6%
8	3	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	57376	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	19304	33.6%
0	12378	21.6%
5	11875	20.7%
6	6659	11.6%
1	2748	4.8%
4	1430	2.5%
9	1131	2.0%
7	932	1.6%
3	916	1.6%
8	3	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	57376	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	19304	33.6%
0	12378	21.6%
5	11875	20.7%
6	6659	11.6%
1	2748	4.8%
4	1430	2.5%
9	1131	2.0%
7	932	1.6%
3	916	1.6%
8	3	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	57376	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	19304	33.6%
0	12378	21.6%
5	11875	20.7%
6	6659	11.6%
1	2748	4.8%
4	1430	2.5%
9	1131	2.0%
7	932	1.6%
3	916	1.6%
8	3	< 0.1%

CAR3
Text

Distinct	31
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Length

Max length	3
Median length	2
Mean length	2.000155
Min length	2

Characters and Unicode

Total characters	38721
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4 ?
Unique (%)	< 0.1%

Sample

1st row	93
2nd row	49
3rd row	49
4th row	92
5th row	90

Value	Count	Frequency (%)
91	7068	36.5%
80	2975	15.4%
90	2332	12.0%
93	1875	9.7%
49	1679	8.7%
95	823	4.3%
31	554	2.9%
92	384	2.0%
98	364	1.9%
19	288	1.5%
Other values (21)	1017	5.3%

Most occurring characters

Value	Count	Frequency (%)
9	15169	39.2%
1	7943	20.5%
0	5313	13.7%
8	3893	10.1%
3	2527	6.5%
4	2166	5.6%
5	877	2.3%
2	619	1.6%
7	203	0.5%
6	11	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	38721	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
9	15169	39.2%
1	7943	20.5%
0	5313	13.7%
8	3893	10.1%
3	2527	6.5%
4	2166	5.6%
5	877	2.3%
2	619	1.6%
7	203	0.5%
6	11	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	38721	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
9	15169	39.2%
1	7943	20.5%
0	5313	13.7%
8	3893	10.1%
3	2527	6.5%
4	2166	5.6%
5	877	2.3%
2	619	1.6%
7	203	0.5%
6	11	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	38721	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
9	15169	39.2%
1	7943	20.5%
0	5313	13.7%
8	3893	10.1%
3	2527	6.5%
4	2166	5.6%
5	877	2.3%
2	619	1.6%
7	203	0.5%
6	11	< 0.1%

CAR4
Text

Distinct	48
Distinct (%)	0.5%
Missing	9174
Missing (%)	47.4%
Memory size	868.8 KiB

Length

Max length	3
Median length	1
Mean length	1.5116348
Min length	1

Characters and Unicode

Total characters	15396
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4 ?
Unique (%)	< 0.1%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Value	Count	Frequency (%)
1	3560	35.0%
2	2845	27.9%
204	754	7.4%
108	695	6.8%
3	495	4.9%
92	333	3.3%
32	220	2.2%
140	190	1.9%
97	178	1.7%
109	137	1.3%
Other values (38)	778	7.6%

Most occurring characters

Value	Count	Frequency (%)
1	4918	31.9%
2	4170	27.1%
0	2001	13.0%
4	1027	6.7%
3	914	5.9%
8	877	5.7%
9	876	5.7%
7	376	2.4%
6	218	1.4%
5	19	0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	15396	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	4918	31.9%
2	4170	27.1%
0	2001	13.0%
4	1027	6.7%
3	914	5.9%
8	877	5.7%
9	876	5.7%
7	376	2.4%
6	218	1.4%
5	19	0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	15396	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	4918	31.9%
2	4170	27.1%
0	2001	13.0%
4	1027	6.7%
3	914	5.9%
8	877	5.7%
9	876	5.7%
7	376	2.4%
6	218	1.4%
5	19	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	15396	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	4918	31.9%
2	4170	27.1%
0	2001	13.0%
4	1027	6.7%
3	914	5.9%
8	877	5.7%
9	876	5.7%
7	376	2.4%
6	218	1.4%
5	19	0.1%

text_to_analyse
Text

Distinct	17118
Distinct (%)	88.4%
Missing	0
Missing (%)	0.0%
Memory size	5.8 MiB

Length

Max length	909
Median length	675
Mean length	145.43442
Min length	26

Characters and Unicode

Total characters	2815465
Distinct characters	136
Distinct categories	18 ?
Distinct scripts	2 ?
Distinct blocks	4 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	16005 ?
Unique (%)	82.7%

Sample

1st row	Después del diagnóstico de HOTLINE No más comunicación, asociación WIFI imposible.
2nd row	Después del diagnóstico de HOTLINE Pasarela de comunicaciones HITACHI RPI problema de comunicacion
3rd row	Después del diagnóstico de HOTLINE Puerta de enlace de comunicación problema de comunicacion
4th row	CAMBIO CPP EN GARANTIA POR PROBLEMAS COMUNICACION CENTRAL DE PRODUCCION fallo en comunicacion central de produccion
5th row	TARJETA POTENTE PARA 8 ZONAS 0000 RAS

Value	Count	Frequency (%)
de	22890	5.2%
no	13707	3.1%
el	11995	2.7%
la	11279	2.6%
termostato	8898	2.0%
en	8848	2.0%
se	6942	1.6%
con	6750	1.5%
y	6531	1.5%
que	6115	1.4%
Other values (19188)	333638	76.2%

Most occurring characters

Value	Count	Frequency (%)
	415293	14.8%
A	145260	5.2%
E	142245	5.1%
e	132062	4.7%
a	120620	4.3%
O	110078	3.9%
o	99558	3.5%
N	95571	3.4%
n	80560	2.9%
T	80249	2.9%
Other values (126)	1393969	49.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1211016	43.0%
Lowercase Letter	1016990	36.1%
Space Separator	415297	14.8%
Decimal Number	98311	3.5%
Other Punctuation	35827	1.3%
Control	25430	0.9%
Dash Punctuation	3829	0.1%
Open Punctuation	2318	0.1%
Other Symbol	2175	0.1%
Close Punctuation	2157	0.1%
Other values (8)	2115	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	132062	13.0%
a	120620	11.9%
o	99558	9.8%
n	80560	7.9%
r	68922	6.8%
t	64136	6.3%
i	64001	6.3%
l	58270	5.7%
s	54820	5.4%
c	52431	5.2%
Other values (30)	221610	21.8%

Uppercase Letter

Value	Count	Frequency (%)
A	145260	12.0%
E	142245	11.7%
O	110078	9.1%
N	95571	7.9%
T	80249	6.6%
R	78609	6.5%
I	78225	6.5%
L	66963	5.5%
C	66131	5.5%
S	59620	4.9%
Other values (29)	288065	23.8%

Other Punctuation

Value	Count	Frequency (%)
.	18659	52.1%
,	9775	27.3%
:	2944	8.2%
/	2358	6.6%
"	404	1.1%
?	375	1.0%
*	373	1.0%
\	253	0.7%
%	158	0.4%
¿	138	0.4%
Other values (8)	390	1.1%

Decimal Number

Value	Count	Frequency (%)
0	19380	19.7%
1	13421	13.7%
2	13032	13.3%
6	12510	12.7%
3	9920	10.1%
5	7236	7.4%
8	6652	6.8%
4	6605	6.7%
7	4874	5.0%
9	4681	4.8%

Math Symbol

Value	Count	Frequency (%)
+	786	77.7%
>	149	14.7%
=	53	5.2%
<	23	2.3%
\|	1	0.1%

Control

Value	Count	Frequency (%)
	12792	50.3%
	12479	49.1%
	158	0.6%
	1	< 0.1%

Modifier Symbol

Value	Count	Frequency (%)
´	3	50.0%
`	2	33.3%
¨	1	16.7%

Space Separator

Value	Count	Frequency (%)
	415293	> 99.9%
	4	< 0.1%

Dash Punctuation

Value	Count	Frequency (%)
-	3824	99.9%
–	5	0.1%

Open Punctuation

Value	Count	Frequency (%)
(	2312	99.7%
[	6	0.3%

Close Punctuation

Value	Count	Frequency (%)
)	2151	99.7%
]	6	0.3%

Other Symbol

Value	Count	Frequency (%)
°	2151	98.9%
™	24	1.1%

Other Letter

Value	Count	Frequency (%)
º	750	95.7%
ª	34	4.3%

Connector Punctuation

Value	Count	Frequency (%)
_	236	100.0%

Initial Punctuation

Value	Count	Frequency (%)
“	27	100.0%

Final Punctuation

Value	Count	Frequency (%)
”	27	100.0%

Format

Value	Count	Frequency (%)
	22	100.0%

Currency Symbol

Value	Count	Frequency (%)
£	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2228790	79.2%
Common	586675	20.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	145260	6.5%
E	142245	6.4%
e	132062	5.9%
a	120620	5.4%
O	110078	4.9%
o	99558	4.5%
N	95571	4.3%
n	80560	3.6%
T	80249	3.6%
R	78609	3.5%
Other values (71)	1143978	51.3%

Common

Value	Count	Frequency (%)
	415293	70.8%
0	19380	3.3%
.	18659	3.2%
1	13421	2.3%
2	13032	2.2%
	12792	2.2%
6	12510	2.1%
	12479	2.1%
3	9920	1.7%
,	9775	1.7%
Other values (45)	49414	8.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2786754	99.0%
None	28606	1.0%
Punctuation	81	< 0.1%
Letterlike Symbols	24	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	415293	14.9%
A	145260	5.2%
E	142245	5.1%
e	132062	4.7%
a	120620	4.3%
O	110078	4.0%
o	99558	3.6%
N	95571	3.4%
n	80560	2.9%
T	80249	2.9%
Other values (83)	1365258	49.0%

None

Value	Count	Frequency (%)
ó	6430	22.5%
Ó	4206	14.7%
í	4022	14.1%
Í	2488	8.7%
°	2151	7.5%
á	2078	7.3%
é	1857	6.5%
ú	1424	5.0%
º	750	2.6%
É	730	2.6%
Other values (28)	2470	8.6%

Punctuation

Value	Count	Frequency (%)
“	27	33.3%
”	27	33.3%
	22	27.2%
–	5	6.2%

Letterlike Symbols

Value	Count	Frequency (%)
™	24	100.0%

processed_text_to_analyse
Text

Distinct	16800
Distinct (%)	86.8%
Missing	0
Missing (%)	0.0%
Memory size	3.3 MiB

Length

Max length	618
Median length	474
Mean length	110.86373
Min length	9

Characters and Unicode

Total characters	2146211
Distinct characters	73
Distinct categories	15 ?
Distinct scripts	2 ?
Distinct blocks	4 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	15550 ?
Unique (%)	80.3%

Sample

1st row	diagnostico hotline comunicacion asociacion wifi imposible
2nd row	diagnostico hotline pasarela comunicaciones hitachi rpi problema comunicacion
3rd row	diagnostico hotline puerta enlace comunicacion problema comunicacion
4th row	cambio cpp garantia problemas comunicacion central produccion fallo comunicacion central produccion
5th row	tarjeta potente 8 zonas 0000 ras

Value	Count	Frequency (%)
termostato	8909	3.2%
funciona	5575	2.0%
airzone	4585	1.7%
central	3566	1.3%
garantia	3306	1.2%
motor	2991	1.1%
radio	2944	1.1%
blueface	2916	1.1%
n	2651	1.0%
cliente	2202	0.8%
Other values (17817)	235263	85.6%

Most occurring characters

Value	Count	Frequency (%)
	255549	11.9%
a	222377	10.4%
e	189516	8.8%
o	173477	8.1%
i	140020	6.5%
t	134114	6.2%
r	131509	6.1%
n	128549	6.0%
c	108204	5.0%
l	86331	4.0%
Other values (63)	576565	26.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1781969	83.0%
Space Separator	255549	11.9%
Decimal Number	98311	4.6%
Other Punctuation	4119	0.2%
Other Symbol	2175	0.1%
Dash Punctuation	2010	0.1%
Math Symbol	1012	< 0.1%
Other Letter	784	< 0.1%
Connector Punctuation	164	< 0.1%
Close Punctuation	45	< 0.1%
Other values (5)	73	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	222377	12.5%
e	189516	10.6%
o	173477	9.7%
i	140020	7.9%
t	134114	7.5%
r	131509	7.4%
n	128549	7.2%
c	108204	6.1%
l	86331	4.8%
s	83085	4.7%
Other values (17)	384787	21.6%

Other Punctuation

Value	Count	Frequency (%)
.	2454	59.6%
/	844	20.5%
\	237	5.8%
:	166	4.0%
%	157	3.8%
"	104	2.5%
,	81	2.0%
@	45	1.1%
'	16	0.4%
*	5	0.1%
Other values (5)	10	0.2%

Decimal Number

Value	Count	Frequency (%)
0	19380	19.7%
1	13421	13.7%
2	13032	13.3%
6	12510	12.7%
3	9920	10.1%
5	7236	7.4%
8	6652	6.8%
4	6605	6.7%
7	4874	5.0%
9	4681	4.8%

Math Symbol

Value	Count	Frequency (%)
+	786	77.7%
>	149	14.7%
=	53	5.2%
<	23	2.3%
\|	1	0.1%

Modifier Symbol

Value	Count	Frequency (%)
´	3	50.0%
`	2	33.3%
¨	1	16.7%

Other Symbol

Value	Count	Frequency (%)
°	2151	98.9%
™	24	1.1%

Other Letter

Value	Count	Frequency (%)
º	750	95.7%
ª	34	4.3%

Open Punctuation

Value	Count	Frequency (%)
(	41	95.3%
[	2	4.7%

Space Separator

Value	Count	Frequency (%)
	255549	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	2010	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	164	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	45	100.0%

Format

Value	Count	Frequency (%)
	22	100.0%

Currency Symbol

Value	Count	Frequency (%)
£	1	100.0%

Control

Value	Count	Frequency (%)
	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1782753	83.1%
Common	363458	16.9%

Most frequent character per script

Common

Value	Count	Frequency (%)
	255549	70.3%
0	19380	5.3%
1	13421	3.7%
2	13032	3.6%
6	12510	3.4%
3	9920	2.7%
5	7236	2.0%
8	6652	1.8%
4	6605	1.8%
7	4874	1.3%
Other values (34)	14279	3.9%

Latin

Value	Count	Frequency (%)
a	222377	12.5%
e	189516	10.6%
o	173477	9.7%
i	140020	7.9%
t	134114	7.5%
r	131509	7.4%
n	128549	7.2%
c	108204	6.1%
l	86331	4.8%
s	83085	4.7%
Other values (19)	385571	21.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2143206	99.9%
None	2959	0.1%
Letterlike Symbols	24	< 0.1%
Punctuation	22	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	255549	11.9%
a	222377	10.4%
e	189516	8.8%
o	173477	8.1%
i	140020	6.5%
t	134114	6.3%
r	131509	6.1%
n	128549	6.0%
c	108204	5.0%
l	86331	4.0%
Other values (51)	573560	26.8%

None

Value	Count	Frequency (%)
°	2151	72.7%
º	750	25.3%
ª	34	1.1%
ø	16	0.5%
´	3	0.1%
¨	1	< 0.1%
£	1	< 0.1%
	1	< 0.1%
·	1	< 0.1%
¡	1	< 0.1%

Letterlike Symbols

Value	Count	Frequency (%)
™	24	100.0%

Punctuation

Value	Count	Frequency (%)
	22	100.0%

Interactions